Querie List

  • Thread starter Thread starter lewy the fly via AccessMonster.com
  • Start date Start date
L

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
 
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
 
JOE said:
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
Click to expand...
[quoted text clipped - 7 lines]
Message posted via AccessMonster.com
Click to expand...
Click to expand...
Thanks Joe
I'll give it a try sounds good.

Lewy
 
Back
Top