Search Form

[gmatriix]

Hello All,

I have been trying to make a search form off a table in my DB....I also have to forms...one for the search and one that returns the results of the search.

form1 - has drop down with a field list that is from the table and a text for the criteria

form2 - Is a list of the fields in the table

What I am trying to do is when I click the search button it opens up form1 and then I select a field from the dropdown that I want to search in and the value to search in the text box below the dropdown

If it finds that records then it returns it to form2...

Any Ideas?????

Thanks

 

[qdogfball]

First, Could you just use the default search?

If that WILL NOT work, then look under the samples in the forum here.

There should be plenty of search databases.