Creating a search function on a table

[Patrick]

I need help trying to create a search function for a project I am doing. I
have two tables, one that contains customer information and another that
contains permit information. The tables are linked by customer number, in a
one to many relationship (i.e. one customer can have several permits). I
would like to create a form that allows me to search by keyword in a selected
field of the customer table. For example a search that allows me to type in
a keyword and return all addresses that contain this keyword. I would like
to have the results returned in table format. I am not sure how to go about
this or if it is possable. I am new to Access 2000 and have been able to
make several forms that show the data from a table. Any help would be
appreciated.

 

[Duane Hookom]

Have you examined queries? Search Help or just go play around in the
queries.

 

[Patrick]

I tried quieries but can not create any that do what I want. I would like to
have a combo box that list the fields of my customer table, after choosing
one I then want to key in a key word. Then I want to return a table with
with customers that match this field. If queries are the way to achieve this
I haven't been able to get it to filter corectly or find a useful example in
the help section of Access 2000.

 

[Patrick]

I have a query that displays all the items I want off the customer table.
Now I want to filter the query on a new form that has a keyword search. I
have a combo box that displays the search by criteria (address, phone, etc)
and then I have a text box that gets the key word. I also have a "Search..."
button that when pressed I would like to see the "filtered" results (it
doesn't do that, but ultimently i want it to). There is also a subform on
this form that displays the query. Where do I go from here?

 

[Duane Hookom]

There are lots of samples, examples, tutorials, etc at Marty Green's site
http://www.fontstuff.com/access/index.htm that go into much more detail than
I can describe here. Come back if you have some specific questions.