Complete search form

[Tillyban]

I have a table called customers and subtables are linked to this table. for example contacts, etc..;

I would like to make a search form where i have criteria fields like street, id code, customername, customername, etc....
I would like to have one Search button so when I enter criteria like the name or the street I just have to click one button. And I would like to have 1 reset button to delete the criteria in the fields so I do not need to clear each time all fields.

also I would like to see in that screen a subform where i can see the found criteria so I can click one button to open customer details.

can someone help me on that issue or does someone have such a form allready?

 

[ansentry]

Have you tried a Search?

 

[jesusoneez]

A guy called Grommit (I think) posted this in the example databases forum. Helped me, and I think it does everything you want it to do.

Regards,

Ste

 

[bonekrusher]

Take a look at this example. I use it in all my DB

http://www.access-programmers.co.uk/forums/showthread.php?t=100246