passing combobox value into sql query MS ACCESS
- by every_answer_gets_a_point
i have a combobox on a form
i want the text of the combobox to be passed into a query.
my query is:
select..from..where something=[Forms]![Enter Data]![comboCup]
the form name is enter data and the combobox name is combocup. should i do:
[Forms]![Enter Data]![comboCup]![text]
or
[Forms]![Enter Data]![comboCup]![value]
??