Drop down option in a query based off a form

  • Thread starter Thread starter matrix7410
  • Start date Start date
M

matrix7410

I have a form named "Provider" that has a combo box field "Combo88"
that gives you drop down option to pick a Provider Name when doing the
data entry on the form. What I would like to do is to create a query
that asks the user to enter the name of the provider from the drop
down - I want it as Drop down choice, not paramter where the user
would have to type in the name. This is strictly for the query
purpose not for the reporting purspose. Can anyone help?

I tried to do this by first creating a query and on the "ProviderName"
field criteria I typed in Forms!Provider!combo88 and it didn't
actually do anything. Any ideas?

thanks!
 
If you set your form criteria to:

Forms!Provider.combo88

then the query will pull data based on what is already selected in
that combobox (the form must be open). the query itself is not going
to "ask" the user to enter a value, it is just going to pull the
selected value of the combobox. is this what you want?
 
It should work the way you did it. I used that option very often and it works
perfect, have you tryed like this:

[Forms]![Provider]![Combo88]

Make sure the Combo88 is unbound (no Control Source)

Try, let me know
 
Back
Top