Getting Data from a combo box to show it seconed column in a text box

E

Empxv

I am working with Access 2000. I have a combo box [FA #] with 2 columns on it and I want the data from the frist column in the FA box and the seconed column to show in a text box called City.
 
J

JeffW

In the AfterUpdate event of [FA #],
me![City] = Me![FA #].Column(1)

HTH,
Jeff

Empxv said:
I am working with Access 2000. I have a combo box [FA #] with 2 columns
Click to expand...
on it and I want the data from the frist column in the FA box and the
seconed column to show in a text box called City.
 
Top