"Filter by Form" form

[pjtarheel]

Hey,

I want to set up a form for end users to be able to select records based on any combination of filters on any records. In other words, pretty much the same thing you get when you use the "Filter by Form" option in the table datasheet view, only I don't want them to be accessing the table directly like that. I want them to use a form so that I can set some audit trails and such.

What is the easiest way to do something like this? I'm using Access 2000.

Thanks!

Paul

 

[Minkers]

Try this database from The Access Web (http://www.mvps.org/access/[/url]) which is in Access 97 format but runs well in 2000.

I have similar code running in my database and find it works rather well.

Minkers

 

[PHV]

Do a keyword search for qbf

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[cghoga]

your coulld have 2 fields
the first, a combo box housing all field names in your form's recordsource (or the fieldnames you need to filter by)
the 2nd field would be a textbox
enter filter criteria in the textbox then click a command button that sets the recordsource of the form based on the field selected from the combo and the text entered
you will need to use the like operator.

Me.Recordsource = "Select Field1, Field2, where .."

hope this helps.