how to get a query to prompt for city

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

Guest

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
 
Try that

Select * From MyTable Where CityName = [CityParam]
That will promopt you with field CityParam to enter a name
 
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
 
Back
Top