combo box selection will not populate query correctly

J

Jecker

I'm really stumped - I cannot get my combo box selection to populate my query
correctly. I have incentive plans listed in the combo box - I want the query
to run the plan that I select from the combo box. The Combo Box on my form
(FRM_Incentive_Plans) is called "cboplans" I want to choose a record in the
combo box and then have my query populate based on my selection. The
criteria I have in my query under the 'plan' field is
[Forms]![FRM_Incentive_Statements]![cboplans]. When I choose the plan in the
combo box, my macro runs the query, however it runs everything instead of the
'plan' that I have chosen. Any ideas?
 
D

Dorian

Try [Forms]![FRM_Incentive_Statements]![cboplans].Column(0)
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Combo or list box 0
Combo box 0
Combo Box Selection is Blank 1
How do I control a text box via another combo box 2
Combo Box Display 3
auto populate text box based on combo box value 1

Top