subform with combo box

  • Thread starter Thread starter Ranen Chaim via AccessMonster.com
  • Start date 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.
 
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]
 
Back
Top