Multi Search Qery

[Firemansam]

Hi,

I'm trying to use a form items to search across multiple fields in a table.

I have setup my form with all the items I want to search on and made them unbound. Then adjusted my query to look for the information in the particular text box on the form. like so;

[Forms]![Search]![Like "*" &[Specialty] & "*"]]

It keeps coming up with and error about the brackets or the syntax.

The result I am looking for is a form with multi text boxs that an end user can pick and choose which field they want to search on and they only need to use a "Keyword" in each text box to geta report.

Any help is a appreicated
Thanks in advance.

FiremanSam

 

[cpberg1]

Fire man,

Try in the query,
add the table you want to search from to the query.
Add the field that you want to search to the query builder.

In the criteria line type: like * & forms!FormName!txtboxname & *

It will probably change to Like "*" & forms!formName!txtboxname & "*"

Change formname and txtboxname to the proper names. Good to go.

Chris

 

[cpberg1]

You'll need Some event to trigger a requery like a button click or a change of the textbox criteria.

 

[John Big Booty]

Perhaps the sample posted here will give you some pointers.