How to (re-)populate combobox in subform

[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

 

[Al Camp]

hstijnen,
You wrote...

table1.field = Me.Parent.SelField

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.