Dynamically updating a combo box fails

[siema24]

Hi,


I have problem with dynamically updating a combobox values based on another combobox choice within one form named frmOne.
It works fine unless frmOne is used as a subform. When opening "parent" form access asks me to type value that will become a criteria for combobox "row source".
Do you guys know if it's a common problem? How to solve it? If you need then I can provide you with more details. Thanks!

[ranman256]

If the combo box is in a sub form, then the query source of the combo must use the full path to the form.
same with a parent form. you can't have it both ways.

either make 2 forms, frmParent,and frmSubForm, each with a separate combo query
select field from table where [field2]=forms!FrmParent!cboBox
and
select field from table where [field2]=forms!FrmParent!subForm!cboBox

or
dynamically swap the query in frmOne depending where it is,
Me.subform!form!cboBox.rowsource="qsSubQuery"