how to get a query to prompt for city

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grd - 30 May 2005 19:20 GMT

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

Reply to this Message

Ofer - 30 May 2005 19:33 GMT

Try that

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

> hi,
>
[quoted text clipped - 5 lines]
>
> Any help would be greatly appreciated

Reply to this Message

Eric Blitzer - 31 May 2005 06:05 GMT

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

> hi,
>
[quoted text clipped - 5 lines]
>
> Any help would be greatly appreciated

Reply to this Message