Form/SubForm Question

  • Thread starter Thread starter depawl
  • Start date Start date
D

depawl

I have a form with a combo box and two subforms. When I select a
vendor's name from the combo box, the vendor's info (address, phone,
etc.) appear in the first subform (this is mainly for the user's info).
What I would like is to have the vendorID also appear in the second
subform (and populate the table), which is where the user enters data
for new items purchased and added to stock. I've tried putting code in
the "On Current" event of both subforms and the "After Update" event of
the combo box, but no luck yet.
Any ideas?
Thanks.
 
I just put the control on subform having
ControlSource equal to VendorId and DefaultValue equal to
Forms!MainForm.YourCombobox.Column(1)
Second Column in combobox should have VendorId. Every new record in Subform
will get VendorId that associated
with Vendor name selected in combobox.
 
Back
Top