Linked forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Combo Box on Sub 9
Connect to sub-form without Parent/Child link 3
If datapoint already exists populate form 2
data entry into one to many tables 1
Data entry form 2
Record split between screens is missing information 1
Set combobox value on Seperate form close 2
Show Vendor Name 14

Back
Top