subform with combo box

  • Thread starter Ranen Chaim via AccessMonster.com
  • Start date
R

Ranen Chaim via AccessMonster.com

I have a subform with 2 combo box where the other combo box depends on what
the value of the other combo box will choose from. when i am trying to see
the form view and test it, its working. but when i link my subform to a
main form, the combo box with criteria in the query and depends on another
combo box does not function well. instead window occur with "Enter
Parameter Value". need help.
 
S

Steve Schapel

Ranen,

I assume the Row Source of the second combobox is based on a query that
uses the first combobox as a criteria. Yes? I would guess that the
criteria in the query needs to be changed to reflect the fact that it is
referring to a subform control. Make it like this...
[Forms]![NameOfMainForm]![NameOfSubform]![FirstCombobox]
 

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
Dependant combo box in subform 2
synchronized Combo Boxes in subforms 2
First Subform record gets modified when closing form 3
Subform dependent combo box 4
2nd Combo box does not change subform 4
Combo box Subform Control Default 2
Subform fields auto-filled based on Main form combo box value 8

Top