subform records

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

I have a subform (Subform 1) within a main form (Form 1) that is joined by
CustomerID. The subform contains information regarding vendors used by each
customer. A user can enter customer-specific vendor information on the main
form and then use the subform navigation buttons to move between records for
the particular customer.

For some reason, when the main form is opened for each customer, the vendor
subform is blank, even though there are indeed vendors entered for that
particular CustomerID. Is there a code that can be used (perhaps in the
OnOpen property) that will cause the subform to display the appropriate
information for each customer?

Thank you in advance for any assistance.

LB
 
Lauren said:
I have a subform (Subform 1) within a main form (Form 1) that is joined by
CustomerID. The subform contains information regarding vendors used by each
customer. A user can enter customer-specific vendor information on the main
form and then use the subform navigation buttons to move between records for
the particular customer.

For some reason, when the main form is opened for each customer, the vendor
subform is blank, even though there are indeed vendors entered for that
particular CustomerID. Is there a code that can be used (perhaps in the
OnOpen property) that will cause the subform to display the appropriate
information for each customer?
Click to expand...


I'm not sure what you're describing here, but maybe you need
to set the subform's Link Master/Child properties to the
customer id field??
 
Back
Top