auto populate fields and save data to table

[joey0127]

Plse Help. In my UpdateForm I have 3 fields. PartNumber, Description and SerialNumber. I use 2 tables for these. My MainTable and PartsList Table.

In my PartsList table I have the list of PartNumber in Column (0) and Description in column (1).

In my MainTable I have 4 fields: TransactionID (autoNumber), PartNumber(text), Description(text) and SerialNumber (text).

Now, In my UpdateForm I want the user to just select the PartNumber with a combo box (that also show the "Description" (I created this using the combo box wizard)). But I want to auto populate the field in my "Description" text box every time the user will enter new record and will also update my MainTable with all the values they entered in my UpdateForm.

I tried this codes in the after update of PartNumber combo box (properties):

Description = Partnumber.Column(1)
I tried also:

me.Description.value=me.PartNumber.column(1)
both codes unsuccessful.

 

[pbaldy]

I wouldn't save the description in the transaction table, but see if this helps:

http://www.baldyweb.com/Autofill.htm

One thing to check if the code fails is the column count property of the combo.

 

[joey0127]

Thanks for the reply. I tried both code u mentioned:
=ComboName.Column(2)....this code made the Description text box auto populate but did not save the value in the Main Table.

Me.TextboxName = Me.ComboName.Column(2)....this code did not auto populate the description text box.

 

[pbaldy]

And did you check:

One thing to check if the code fails is the column count property of the combo.