How to (re-)populate combobox in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've a form with a data entry field SelField and a subform. The subform
contains a combobox. Now I want to (re-)populate the combobox dependant from
the value in the Field.
The Rowsource Type of the combobox is Table/Query.
The Row Source is now like:
Select name from table1 where table1.field = Me.Parent.SelField
But that doesn't work.
Can anyone help to fill the row source correctly?

TIA

Henk
 
hstijnen,
You wrote...
table1.field = Me.Parent.SelField
Click to expand...
I thought you said the field on the main form was named SelField?

In your combo query use this criteria...
= Forms!frmYourMainFormName!SelField
Also, Requery the combo whenever SelField changes.
 
Back
Top