Form type search engine.

  • Thread starter Thread starter Travis
  • Start date Start date
T

Travis

I'm just getting started on a new database and need some
help. What I need help with is. Building a form that acts
as a muti-characteristic search engine. Let me explain.
What I want to be able to do is have a form that when
opened up will ask the user for up to 15 different
characteristics. The user will then enter in as many as
they need (but only up to 15) and press search. The
database will then search through all the records and find
all the people that match those characteristics. Please
help me. Thanks in advance for any and all help.

Travis
 
Travis said:
I'm just getting started on a new database and need some
help. What I need help with is. Building a form that acts
as a muti-characteristic search engine. Let me explain.
What I want to be able to do is have a form that when
opened up will ask the user for up to 15 different
characteristics. The user will then enter in as many as
they need (but only up to 15) and press search. The
database will then search through all the records and find
all the people that match those characteristics.
Click to expand...


For simple searches, you can set the form's record source
query to use criteria something like:

=Forms!theform.atextbox OR (Forms!theform.atextbox Is Null)

on each field you want to be able to search and you have set
up a text box for users to enter the search values.

Another way is to dynamically construct the form's record
source query's SQL. While I usually prefer this approach,
it can take a significant amount of code and I'd rather not
go into it unless you're fairly proficient with VBA. If you
want to pursue it, please post back with a list of the field
names and types, what the control names on the form are and
the kind of search you need to do.
 
Back
Top