Adding a search form

[sevanty7]

Hello,

I current have within my database:
tblMain
frmSearch - 7 different text criteria boxes and 1 buton label search


frmSearchResults

What i need to do is have users type in data into any of the textboxes (with wildcards enabled) and have it so that a macro or code runs that finds related entries and displays them into a new form called frmSeachResults.

Thank you for any help you can provide, I know i have done this in the past but i cannot seem to get anything i try to work.

[pbaldy]

For that many options I use dynamic SQL, demonstrated in the sample db here:

http://www.baldyweb.com/BuildSQL.htm

it could be adapted to populate a new form.