G Guest Feb 22, 2004 #1 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.
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 Feb 22, 2004 #2 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.
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.