Querying Access Databases - Advanced??

[luke2k02]

I have been having quite a bit of difficulity with Microsoft Access 2000, and queries etc.

I would like to be able to enter search details in a form, and have the results popup in another form.

And the other thing, when I try to look for a field called "Mexican Cooking" by just typiong in "mexican" it finds no matches - is there any way to make this work.

I WOULD REALLY APPRECIATE A REPLY ASAP - the assignment is due on Monday, and I have sooo much stuff to do. Thanks guys/chicks.

 

[MangroBongacello]

For the 1st q:

On the button to open search results form OnClick event:

Dim strCriteria as string
strCriteria = "FieldInResultsForm=CorrespondingTextBoxInSearchForm"
DoCmd.OpenForm "ResultsForm",,,strCriteria

See OpenForm method help topic for more info.

2nd q: Use the like operator (ie Like Criteria & *).

To use this feature for previous purpose, it will look something like this

DoCmd.OpenForm "ResultsForm",,,"FieldInResultsForm Like '" & TextBoxInSearchForm & "*'"

Watch for single quotes! After Like there is space, single quote, double quote....After the * there is a single quote, then double quote.

Good luck
Mangro