G
Guest
I have a form that is linked to several tables. The form is used to create
an invoice record in a table called Invoices.
There is a section where I select parts that are being purchased. There are
many combo boxes each getting its values from a field called Part # in a
table called Parts.
When I select part #'s I want several things to happen, but I'm having
trouble getting all but one to work. This is what I want to happen:
1. The selected Part # gets stored in a field called Part # in the Invoice
table.
This works because I made the control source equal to that field in the
Invoice table.
2. I want the Part Description (obtained from the Parts table) of the
selected Part # to populate a text box on the form.
3. I want the Description to get stored in the Description field of the
Invoice table.
4. I want the same thing to happen for Part Price and Part weight.
I can only get 1. to work. I appreciate any help.
Thanks,
Anthony
an invoice record in a table called Invoices.
There is a section where I select parts that are being purchased. There are
many combo boxes each getting its values from a field called Part # in a
table called Parts.
When I select part #'s I want several things to happen, but I'm having
trouble getting all but one to work. This is what I want to happen:
1. The selected Part # gets stored in a field called Part # in the Invoice
table.
This works because I made the control source equal to that field in the
Invoice table.
2. I want the Part Description (obtained from the Parts table) of the
selected Part # to populate a text box on the form.
3. I want the Description to get stored in the Description field of the
Invoice table.
4. I want the same thing to happen for Part Price and Part weight.
I can only get 1. to work. I appreciate any help.
Thanks,
Anthony