Linked forms

Y

YVETTE

I have a vendor code field in multiple tables that I am using as a link. I
have one main form which has general information and then linked forms. I
have it linked so that the vendor code must exist in the main form before it
can be entered in any of the linked forms.

When they enter a new vendor, they complete all the information on the main
form and then click on the next linked form that they need to enter into.
When the linked form opens on a new vendor, I want the vendor id to auto
populate.
 
B

Brian

Set the default value of the control bound to VendorID on the linked form to:

=[Forms]![NameOfMainForm]![VendorID]

Make this control hidden on the linked form, since the user already knows
who the vendor is from the main form, and you probably do not want the user
changing it.
 
Top