Form not populating correctly

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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.
 
-----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...
 
Back
Top