How do I make a search form??

[Scott]

Can I setup up a "search engine" so to speak that will search through a list of topics contained in my database?

I have a database setup with a "library" of resources I have. I have a topics entry form that allows me to enter topics that certain recources may cover.... and there are multiple topics with the same title. For example, I may have a number of resources that are related to one particular topic.

Can I setup a "search form" that allows me to enter a word (i.e. a topic) and will search a particular field for that topic and all associated resources related? I know how to query, but wasn't sure how I would set it up without having to re run query for new infomation every time.

Thanks,
Scott

 

[Eric Cárdenas [MSFT]]

Can I setup up a "search engine" so to speak that will search
through a list of topics contained in my database?
I have a database setup with a "library" of resources I have. I
have a topics entry form that allows me to enter topics that
certain recources may cover.... and there are multiple topics with
the same title. For example, I may have a number of resources that
are related to one particular topic.
Can I setup a "search form" that allows me to enter a word (i.e. a

topic) and will search a particular field for that topic and all associated
resources related? I know how to query, but wasn't sure how I would set it
up without having to re run query for new infomation every time.

Thanks,
Scott

--------------------
Hi Scott,

Unfortunately, Microsoft Access has very limited full text capabilities. If
you move your data to SQL Server, you can use more powerful full text
capabilities.