4charity
asked on
Update Control on One subform with value from another Subform
I have 2 subforms on a form, frmInvoiceDetail1.
They are:
frmVendor_ClaimDropDown and frmRunningAmtsInv.
When the [VendorName] on the first form is populated, I would like to populate the [Vendor] control on the second.
I am not sure where to set this event, so that it consistently works. Right now, I have code set on the After Update event on the [VendorName] control.
This is the line of code I am using:
Forms![frmInvoiceDetail1]! [frmRunnin gAmtsInv]. Form![Vend or] = Me.VendorName
They are:
frmVendor_ClaimDropDown and frmRunningAmtsInv.
When the [VendorName] on the first form is populated, I would like to populate the [Vendor] control on the second.
I am not sure where to set this event, so that it consistently works. Right now, I have code set on the After Update event on the [VendorName] control.
This is the line of code I am using:
Forms![frmInvoiceDetail1]!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you getting any error message?
Are you sure the code is running- add in a msgbox to check.