Need Help Creating a Multi Search Form

[Jayz]

Can someone please show me how to create a search form that will open another form with the results.

Here's the scenario:
I have one form which contains the data [dataform] with the following fields:
[sub_date]
[company]
[product]
[Country]

I have a search form [searchfrm] with the following text & combo boxes:
[first_date]
[Last_date]
[company1](this is a combo box)
[product1](this is a combo box)
[Country1](this is a combo box)

And a button named [cmdsearch].

I would like to have the user enter info into any Or all of the boxes in the [searchfrm]and click on the button [cmdsearch] which will open the form [dataform] and display the filtered results from the users entry.
At the same time, if the user just enters a few characters into any of the boxes (other than the dates) it will produce a wildcard search.
eg entering "a" in [company1] and "c" in [product1]will produce all company's begining with "a" and have products begining with "c"

Can somone please supply step by step instructions on how to go about doing this.

Much appreciated:=)
Jay

 

[Jayz]

I need help urgently.

Rgrds,
Jay

 

[Jayz]

I know this is not new but I'm hoping someone has an answer.
There are many posts on this topic but I find them very hard to follow or they're not exactly what I need.

Any help would be greatly appreciated.

Regards,
Jay

 

[DJN]

Have a look at the Microsoft Knowledge base.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q136062

 

[jerseyboy]

DJN,
If you search for Thread 702-236472 it has the answer to what you are looking for....
If you are good at looking and getting the answers on your own you can go directly to my example:

http://www.geocities.com/officeteach

This search includes only one search criteria, but it could easily expand to what you are looking for.

Have fun, JerseyBoy
Remember: self-praise is no recommendation