Take a look at:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Raul Sousa" wrote in message
...
I have a database with client's details.
Clients table has several fields; name, address, code, etc.
Sometimes users may need to search for one or several fields.
I was thinking of starting with an unbound form with all clients table
fields.
The user fill all fields he may want to search for . hit the search button
and another form show the results.
I have not done something like this. I have done it with only one field
searchable.
So, any suggestions are most welcome.