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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box, Unbound Text Boxes 2
auto populate text box based on combo box value 1
Can you send values from 2 columns in a Combo Box to 2 text boxes? 5
filter on combo box possible? 1
Selection from combo box doesn't fill text box 2
Update Text Box 3
Can a Combo Box send multiple data outputs? 7
sum combo box based on other combo box 2

Back
Top