Filter records with a form

[johnlewiswhitfield]

In my application I need to allow users to filter records by selecting
criteria on the form that I use to display data, just like the built in
Filter by Form feature of Access. I have recently learned that using the
built in Filter by Form is not an option in the run time version of Access,
nor is using the RunCommand acCmdFilterByForm in a function from a customer
toolbar button. Does anyone know what the solution is to implement form
filtering in run time Access? Is it possible to do this with my existing data
display form, do I need a query or SQL or is there a way to tap into some
other built in command? I would be greatful for any pointers in the right
direction.

Thanks.

 

[Allen Browne]

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

The article explains how to build the Filter string from any combination of
boxes where the user entered search criteria, and it includes a sample
database to demonstrate how. (Access 2000 or later.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...