creating a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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".
 
Back
Top