Subform Records

[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 based on the common Customer ID?

 

[Ofer]

Did you link between the main form to the sub form?
By linking the child and father properties on the sub form.
or did you link between them in a different way.

if you filtered the recordsource of the sub form by linking it to the field

 

[Lauren B]

I linked the subform and the form in a parent/child relationship by Customer
ID. Is there a code I can enter to refresh the page?

Thanks.

 

[Ofer]

No, it supose to do that auto

I linked the subform and the form in a parent/child relationship by Customer
ID. Is there a code I can enter to refresh the page?

Thanks.

 

[nellie almodovar]

I linked the subform and the form in a parent/child relationship by Customer
ID. Is there a code I can enter to refresh the page?

Thanks.