autopopulate not working

[slimjen]

all,
using access 2003. have a form based on a table. have a combo box based on its own recordsource(table). I would like to autopopulate another field on the form once i select a record from the combobox. ex.
the combobox recordsource contains an id field and description. when i select the id from the combobox i would like the description in the text field next to it to autopopulate. I have tried the following in the control source of the text box:

Me.TextboxName = Me.ComboName.Column(2)

doesnt work. gives me the error #Name
what am i doing wrong
Thanks

[pbaldy]

That is VBA code that would go in the after update event of the combo. The control source of the textbox would be the name of the field you want that data stored in:

BaldyWeb - Autofill

[slimjen]

I did this. me.txt_Carriername=me.CarrierID.column (2)? I am placing this in the control source of the field named txt_Carriername where I want the data placed in the table.

[pbaldy]

Again, that is VBA code that can only go in the VBA editor. It will error as the control source.

[slimjen]

O ok. so how do I get this field to populate for the combo box?
Thanks

[pbaldy]

Like I said, that code is intended for the after update event of the combo:

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

[slimjen]

Got it! So can I use the same concept when I want to pull up a previous id# and have it pull up the corresponding record? ex.
When the user types in an invoice # for a previous entered record on a subform; can corresponding fields be populated based on the invoice #? Do I use the same concept VBA code?
Thanks

[pbaldy]

I'm not clear on what you're doing, but presuming you want to pull information related to the selected item in the combo, sure.