Form/Query Question

[Dirk_Bob]

I have created a form with a text box to enter a zip code. Once the user
enters the zip, I want to look up that number in a query.

How do I link the number entered in the text box to the zip field on the
query?

 

[KARL DEWEY]

Put this as criteria in the query.
[Forms]![YourFormName]![YourTextBoxName]
You must have the form open and enter data before running the query.

 

[Dirk_Bob]

Thanks Karl When I do this a get a pop up box asking for the information
again, how can I eliminate the popup box?
--
Dirk

Put this as criteria in the query.
[Forms]![YourFormName]![YourTextBoxName]
You must have the form open and enter data before running the query.
--
KARL DEWEY
Build a little - Test a little

I have created a form with a text box to enter a zip code. Once the user
enters the zip, I want to look up that number in a query.

How do I link the number entered in the text box to the zip field on the
query?

 

[Douglas J. Steele]

As Karl said, the form must be open when the query runs. If it is, make sure
that you typed the names of the form and text box correctly.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks Karl When I do this a get a pop up box asking for the information
again, how can I eliminate the popup box?
--
Dirk

Put this as criteria in the query.
[Forms]![YourFormName]![YourTextBoxName]
You must have the form open and enter data before running the query.
--
KARL DEWEY
Build a little - Test a little

I have created a form with a text box to enter a zip code. Once the
user
enters the zip, I want to look up that number in a query.

How do I link the number entered in the text box to the zip field on
the
query?