Rollin_Again
08-17-2004, 11:29 AM
I have an Access application that has two forms. The first form is called "frmVendors" and the second form is called "frmVendorContacts" The second form "frmVendorContacts" is used to display specific detailed contact information about the Vendor selected on the first form (they are linked by ID numbers)
After adding a new Vendor using the first form, I display the second form (frmVendorContacts) so that I can add a corresponding Contact record for the new Vendor. I have used the command
DoCmd.OpenForm "frmVendorContacts", , , , acFormAdd to open a blank VendorContact form that will be filled with various contact info. I would like to automatically populate one of the text fields on the second form (conID) with a variable value from the first form (venID.) This variable (venID) gets its value from an auto-ID field on the first form.
How do I do this? Sorry for my ignorance, I am only used to working with custom designed forms and using VB not these forms that are automatically created by Access using all these built in commands.
Rollin
After adding a new Vendor using the first form, I display the second form (frmVendorContacts) so that I can add a corresponding Contact record for the new Vendor. I have used the command
DoCmd.OpenForm "frmVendorContacts", , , , acFormAdd to open a blank VendorContact form that will be filled with various contact info. I would like to automatically populate one of the text fields on the second form (conID) with a variable value from the first form (venID.) This variable (venID) gets its value from an auto-ID field on the first form.
How do I do this? Sorry for my ignorance, I am only used to working with custom designed forms and using VB not these forms that are automatically created by Access using all these built in commands.
Rollin