subform update

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.
 
A

Allen Browne

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.
 

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

subforms 5
Copy old subform records to new Form's subform 1
Populate subform field on Afterupdate of main form field 6
update a main form combo box from subform info 1
Subform Combo Record Source Issue 1
Exicute an append query in an after update event 0
Populate query in a subform based on selection from combobox in main form 0
INSERT a Table (32 items) into another Table - Re subform 5

Top