Posting Auto Form Data to Tables

[RWPerkinsJr]

I am trying to make a Invoices Database that uses a combo box to relay information to a text box from a table I created named Part Numbers. All works great except the text box will not save any form data to the table. I am using 2 columns in the combo box. The Part Number I want to store is in column 0 the description is in column 1. I find the PN (Part Number) I want and click it. The database saves the part number in my PN1 in the table. In the text box I use:=[pn1].[column](1) in the control source. Since My part number is in column(0) and the description is in column(1) I get the right result but the description will not save to my D1 field in the table. Can anyone help me? Please?

.

 

[RWPerkinsJr]

I do need it in my table so I can make Reports that have all the information on them. I am new to this and still trying to get the relational part of this. In my reports I can get all the information from my main database EXCEPT the description. Therefore I assume I am going about it the wrong way or I need to use different code in After Update or something like that. I want ALL of the information stored in the Main database.

RP

 

[RWPerkinsJr]

Okay I will Try This. After All You Are The Expert.