creating a query?

C

CarolM

Hi Everyone

I'm hoping theres a really easy answer to this and i'm just being dim :) I
know how to write a query and open the query using a command button but i
would really like to have a field at which says name:______, when someone
enters a name eg smith, and hits return a new table would open with a the
records that match the name smith. I would like to do this with several of
the fields.

I have a form that lists information as:

Dateonletter Reply RefNo Name Product Issue

this displays all the records within the table.

I really hope someone can help as im going round in circles and getting
no-where fast :)

Many thanks

Carol
 
C

CarolM

Hi Jeff

That was one option but for our purposes it would fit in better to have
another screen open. I thought i should be using the after update option but
im not sure how to get it to only find the records that match what we have
entered.

Thanks

Carol
 
J

Jeff Boyce

Carol

At least a couple of options available to you. One would be that you build a
bit of code that inspects your form and dynamically create a filter/WHERE
condition, based on which fields have selection criteria, and which
criteria. Another approach would be to use filter-by-form.

You might try searching Google.com and/or the mvps.org/access websites for
"filter form".
 
Top