Search enabled Form

  • Thread starter Thread starter nicolascaprais
  • Start date Start date
N

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
 
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
 
Back
Top