multicriteria seach

[inoxo]

I'm looking for a form to be filled by the user and then run a search in a table to find matching records. The idea is : the user fills what he can and the program searches all matching records. The form should contain several fields so the search would run on multiple criteria. Filled values filled could be ranges.
Certain fields (=criteria) could be optional.

Example :
name : begins with "SM"
forename : not filled (= all)
age : between 20 and 30
city : Tromso
experience (nb years) : > 3

This should already exist somewhere as a generic form; that's what I'm lloking for.

Thanks.

 

[gromit]

Hi -

Take a look at the following site
http://support.microsoft.com/?kbid=304302

The general approach is to write some VBA code that looks at each of the criteria boxes, builds a SQL statement and runs a query to fill a form or subform.

Hope that helps,

- gromit