Querie List

[lewy the fly via AccessMonster.com]

I have created a select querie, when I run it it has a box comes up that
askes me to type in the data to select, how can I turn that into a drop down
list to choose the data.

Regards

Lewy

 

[JOE]

There might be a shortcut, but the only way I can think of is to create
a form based "application" for this task. On the form, add a combo
box, let the source of this combo box be an SQL statement that displays
the unique values you would want to chose from, and upon some event
(perhaps an OnClick of a command button on the form), execute the query
based on the value of the combo box. Make sense?

JOE

 

[lewy the fly via AccessMonster.com]

There might be a shortcut, but the only way I can think of is to create
a form based "application" for this task. On the form, add a combo
box, let the source of this combo box be an SQL statement that displays
the unique values you would want to chose from, and upon some event
(perhaps an OnClick of a command button on the form), execute the query
based on the value of the combo box. Make sense?

JOE

I have created a select querie, when I run it it has a box comes up that
askes me to type in the data to select, how can I turn that into a drop down

[quoted text clipped - 7 lines]

Message posted via AccessMonster.com

Thanks Joe
I'll give it a try sounds good.

Lewy