Form/SubForm Question

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

Serguei Makacharipov

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.
 

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

Form with 2 Subforms 2
Form/SubForm Question 1
problem with bound control from form to subform 1
Multiple Subform - Endless Loop Problem 4
Displaying Subform with a combo-box 3
Combo Box to Populate a Subform 2
Subform/ComboBox Question 2
Problems with Drop Down Populating with current data 1

Top