Searchable Form

[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

 

[Boze]

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

 

[Bob M via AccessMonster.com]

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