Creating Drop Down Menus

[James]

I'm new to Access, I've found out that you can get prompts by typing in
[please enter value here]

What do I need to do, to create a drop down menu in stead of the simple
prompt?

THanks

 

[tina]

create a form and add a combo box to display the values you want to choose
from. then change the criteria in the query from parameter (your current
criteria) to Forms!FormName!ComboBoxName.
the form must be open and a value selected before you open (run) the query.
you may find it handy to add a command button to the form, to open the
query.

hth

 

[James]

thanks for the fast reply.
Is there no simpler way of doing it, without having to have a form open?
Thanks

create a form and add a combo box to display the values you want to choose
from. then change the criteria in the query from parameter (your current
criteria) to Forms!FormName!ComboBoxName.
the form must be open and a value selected before you open (run) the query.
you may find it handy to add a command button to the form, to open the
query.

hth

I'm new to Access, I've found out that you can get prompts by typing in
[please enter value here]

What do I need to do, to create a drop down menu in stead of the simple
prompt?

THanks

 

[Duane Hookom]

No, this is the same method we all use.

--
Duane Hookom
MS Access MVP

thanks for the fast reply.
Is there no simpler way of doing it, without having to have a form open?
Thanks

create a form and add a combo box to display the values you want to choose
from. then change the criteria in the query from parameter (your current
criteria) to Forms!FormName!ComboBoxName.
the form must be open and a value selected before you open (run) the query.
you may find it handy to add a command button to the form, to open the
query.

hth

I'm new to Access, I've found out that you can get prompts by typing in
[please enter value here]

What do I need to do, to create a drop down menu in stead of the simple
prompt?

THanks