Search Forms

[jesusoneez]

Kind of related to my other post but a seperate question.

I once saw a database where the designers had created a form that at first sight was blank. You could click in any of the many text boxes on the form, enter some data, click a command button labelled "Search" and it would display all records (within that same form) with that search criteria.

Just wondering how someone would go about doing something like this? It's a shame I haven't got this database otherwise I'd have a look, but I can't figure out how it was done with creating about 50 queries and attaching each one to the individual text fields (somehow).



Ste Swallow

 

[carash77ash]

Create a command button with wizard you have an option of find record. it is the easiest way


Ash

 

[jesusoneez]

Heh, easy as that eh?

Thanks.