Making the query ask for input

[Dig]

I have created a query that is for looking up certain information in a table.
It all works fine but what I would like to do is have the query ask for
input to use as a filter when it runs.

So say I want to filter information based on zipcodes. How do I get the
query to start by putting up a box with a blank input field for me to type
in an
area code for the search?

Hope I am making myself clear.

Thanks again for all the help.

 

[fredg]

I have created a query that is for looking up certain information in a table.
It all works fine but what I would like to do is have the query ask for
input to use as a filter when it runs.

So say I want to filter information based on zipcodes. How do I get the
query to start by putting up a box with a blank input field for me to type
in an
area code for the search?

Hope I am making myself clear.

Thanks again for all the help.

One way is like this.

As criteria for the Zip Code column, write:
[What Zip Code?]

You will be prompted for the exact Zip code wanted.

A better way, as some Zip codes may be 5 and others 9 digits, is this
way:
Like [What Zip Code?] & "*"

Entering any part of the Zip code will return all records that begin
with those numbers, i.e. enter 21236 and all 21236-0000 through
21236-9999 zips will be returned.