Combo Box and Keyword Searches

[AMY]

Background Info: I have a massive list of reference
material in table. I want to create a form that will have
two boxes, one will be a box for users to type in Keywords
and will look this up in the keyword field in my table.
The other box i want to put on my form is a combo box. I
have about 15-20 different topics in the table. I want to
somehow pull up a combo box of all these diffent topics so
users can select a topic and then based off of their
choice will produce a list of material. Is this
possible? If so how would I go about doing this? I am
using Access97.

Thanks so much for your help.

 

[joemach]

Yes,

This could be done with a Pop Up form and queries.

 

[joemach]

Yes,

This could be done with a Pop Up form and queries.