how do i simulate EXCEL auto filter in ACCESS

[Guest]

What I mean is can I have a Form/Subform that has a Listbox /Combo Box above
each field and do searches on the main db and return relevant data that can
be viewed and edited below the relevent Listbox/Combo box

 

[BillCo]

you can if you can program VBA. Create a dynamic query based on input
controls... it's been covered to death in these newsgroups, so i'm sure
you'll find a good example if you want to go down this road.

Another option is to use the form controls as a parameter source in a
static query... will require working around null values.

But based on my guess of where you are at experience-wise, the best
option is to use the native access "filter by form" feature while in
datasheet view. It's kinda similar and well documented.