J
JohnT
OK, here's the problem...I have setup my own inventory database consisting of several forms and tables and I am having trouble getting it to do what I would like. I have a form and table called INVOICES as well as a form and table called PARTS. When I load the INVOICES form I am able to fill in information related to particular jobs, to include parts that are used on each job. I have 3 controls as follows: QUANTITYUSED1, PARTUSED1, and PARTUSED5. The QUANTITYUSED1 control is simply a text box control, the PARTUSED1 control is a combo box control, and the PARTUSED5 control is a text box control which updates according to what part is selected from the PARTUSED1 combo box. The PARTUSED1 combo box contains part numbers and when selected the PARTUSED5 text box updates with the name of the part. I have the PARTUSED1 combo box ROW SOURCE set to my PARTS table. Now, what I would like to do is when I fill out the parts section of my invoice form, is for it to automatically deduct from my PARTS table the quantity used for the particular part I select from the PARTUSED1 combo box control on my INVOICE form. Is there any way to do this? Thanks