Combo Box on Unbound Form as Parameter for Query

  • Thread starter Thread starter Tom \T\
  • Start date Start date
T

Tom \T\

Hello everyone,

I currently have an Unbound Form with 2 parameters "Start Date" and "End
Date" that I use to enter parameters into a query. I want to add a 3rd
parameter but want it as a combo box based on the "Cities" field. Is it
possible and how?

Tom "T"
 
If what you're saying is you want to have a combo box on the form that
displays in its dropdown list the choices from "Cities", the answer is yes.

Set the control source of the combo box to a query that returns the values
of "Cities" field from the table. Then use the combo box name as the
parameter in the query:
[Forms]![FormName]![ComboBoxName]
 
Back
Top