Form not populating correctly

G

Guest

I have 2 tables. One a lookup and the other with detail.
I have a list box in my form header and depending on the
list value, want to populate the detail records. The form
I created pulls all the data from the detail table (not
just the records for the selected list value)

Is there some code I need to write?

Thanks
 
N

Nikos Yannacopoulos

No, you don't necessarily need code. Open the form in design view, select
the subform, display properties, select tab Data, and in the Link Child
Fields and Link Master Fields properties select the field(s) the form and
the subform should be linked on.

HTH,
Nikos
 
G

Guest

Nikos

I have checked that ...yet the form is not populating
properly. Some times it tells me that it cannot create a
link between 2 unbound objects.
 
G

Guest

-----Original Message-----
No, you don't necessarily need code. Open the form in design view, select
the subform, display properties, select tab Data, and in the Link Child
Fields and Link Master Fields properties select the field (s) the form and
the subform should be linked on.

HTH,
Nikos




.
Click to expand...
 
Top