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

filter query on combo box in a continuous subform 0
Combo Box Selection is Blank 1
Running A Macro Based on Selection From Combo Box 1
Combo Box - Ability to select All 2
Combo Box question. 3
Combo Box Display 3
Populating text box based on selection in two combo boxes 3
combo box selection 2

Top