subform update

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

Bill H.

I have a form that contains one subform, called Frm_Expense_subform.

On the main (parent) form I have a combo box. When a user makes a
selection from the combo box, I want to update the rowsource property of
fldComboBox on the Frm_Expense_subform with a particular SQL string (which I
build based on the main form combo box).

How do I "transfer" the strSQL from the main form to the rowsource of a
combo box on the subform?

Thanks.
 
You could use the AfterUpdate event of the combo on the main form, e.g.:
Me.Frm_Expense_subform.Form!fldComboBox.RowSource = "SELECT ...

Alternatively, you could use the Enter event of the combo.
 
Back
Top