how to get a query to prompt for city

G

Grd

hi,

i have a query which i use. I can go to the design view and put in the city
I want in the criteria. But how do I get it so I don't have to keep going in
to change it. i.e to make it prompt with a box where I can type the city.

I've seen it before so I know its possible

Any help would be greatly appreciated
 
O

Ofer

Try that

Select * From MyTable Where CityName = [CityParam]
That will promopt you with field CityParam to enter a name
 
E

Eric Blitzer

Ofer has a good solution but why not use a form with a combo box for the city
and any other criteria and add a commad button that runs the query.

Chris
 
Top