Search enabled Form

[nicolascaprais]

hello, I am using Access 2k2-
I'd like to create a form where the users enter words in a combo box.
Then on a click event I'd like to have Access look for each of the words
in a specific table and return the hits in a report.

I know this question is rather not precise, but I am only starting this
part of my project and I'd like to have some hints on how I should think
of the solution to this problem...

Like using VB functions or....

cheers
nico

 

[Howard Brody]

How many words are you going to allow thenuser to search
for at once? Create than many TextBoxes on your form.
ComboBoxes would be even better if there is a specified
number of words the user can use (ie: 50 states) because
they reduce the chance of bad data and errors.

Build a query to pull the data you want and reference the
TextBoxes as the criteria.

Build the report using your query as the source.

Hope this helps!

Howard Brody