FORM TO DISPLAY SEARCH RESULTS 4

[baybie]

Hi, I wish to create a search form with the following fields
Company Name
Customer Name
Order ID
CHPartner

I would ideally like the user to be able to enter criteria in one, some or all of the fields and then press a button and either view the results in a sub-form or in another form. Is this possible?

Many thanks

 

[addy]

I forgot to mention, in the above example, SearchField1, SearchField2 etc. are the names of the unbound text fields on your search form, and Field1, Field2 etc. are the corresponding fields in the table (or query) you want to search on.