Advanced Search

[Guest]

Hi

I need to recreate the advanced search form used in Excel used in its Custom
autofilter function.

I plan to create series of datasets that a user can choose and then using
this advanced search form have it return the selected records that meet the
criteria.

Many thanks

chris

 

[Arvin Meyer [MVP]]

You might want to take a look at using "Filter By Form". The button with the
funnel and form on the toolbar in form view will let you experiment with
this technique.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access