Searchable Form

  • Thread starter Thread starter Andi
  • Start date Start date
A

Andi

I have created a database 'Input Form' relating to all the fields that
I need in order to input a new Contact into my database. Now I need to
create a blank form which is searchable for any field of this database.

I can create an individual query for each bit of information, but was
hoping to just make one form where you could input any name/letter into
the name field and put any date into the form and have the combined
results as a report. Anyone know how I could do that?

How can I do this and make a Switchboard item for it?

Thank you for any help!

-Andi
 
Andi,

Did you find any way to do this search? I've been trying to do the same
thing but haven't figured it out yet.

Boze
 
Why not put the searches in the criteria of a query that is the base of the
report? If you want to search for exact entries use something like this in
the criteria:
[Enter Name ]

If you want to search for partial entries use this in the criteria:
Like "*" & [Enter Name or partial Name] & "*"

It will ask the user for the differnent criteria and then run the report when
the report is opened from wherever you wnat, including the Switchboard
 
Back
Top