I need help with a search form

LeslieB

Registered User.
Local time
Today, 11:59
Joined
Apr 11, 2001
Messages
10
I'm having problems even approaching how to go about doing this particular form.

I'm making a DB app used for searching for company documentation on the company intranet. There are 6 products, therefore 6 tables (no relationships). Each table has one field called Description, which is a brief description of what the document is about.

My manager asked me to create a search form that will do the following:
"You can type in a keyword and search all the description fields in the 6 tables and then list all the documents that mention that keyword in the description. See a few of the documents might mention more than one product."

I've done an exhaustive search on Access help but I'm still floundering about what direction to take here. Can someone offer any starting points?

Leslie
 
Thanks, but the form you sent was more or less a layout form. I need to know what type of query I should use or should this be done using VBA?

HELP!
 
The query is on the list box on the form. If you have more questions email me.

DES
 

Users who are viewing this thread

Back
Top Bottom