Using a Combox value to populate another field on a form

[miki]

Hi people,

I hope everyone is having a great day! Now to business.
I'm really a newbie and can't quite make out how to do
some things.

I have built a combo box with three values from a query. I
am populating one form field with the first column, and I
want the value in the second column to change when I
select from the drop-down-list (ddl) again. I have this
code in record source

=[Forms]![AddTrackingItem]![cbPO_no_list].Column(1)

That works fine for the first selection. If I select
another value on the list in the combo box, this field
does not change. I can't figure out what to do. Can I get
a little guidance?

Thanks

Miki

 

[Chip M]

I would bet that your bound column is not set correctly
under the Data Tab of the properties of the combo box in
question... try changing it to 2 or 3 or 4....(I just had
the same problem!!!)

-Chip