creating a query?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CarolM - 06 May 2005 12:46 GMT

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

Reply to this Message

Jeff Boyce - 06 May 2005 12:57 GMT

Carol

Have you looked into using the form itself and filtering by form?

Signature

Good luck

Jeff Boyce
<Access MVP>

> Hi Everyone
>
[quoted text clipped - 17 lines]
>
> Carol

Reply to this Message

CarolM - 06 May 2005 13:16 GMT

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
>
[quoted text clipped - 21 lines]
> >
> > Carol

Reply to this Message

Jeff Boyce - 09 May 2005 11:56 GMT

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

Signature

Good luck

Jeff Boyce
<Access MVP>

> Hi Jeff
>
[quoted text clipped - 33 lines]
> > >
> > > Carol

Reply to this Message