Getting info from another table

[TRWguy]

In one of the forms i have on my database I have two fields, one is a code and the other is a city that matches that code. There are other fields but they aren't important. What I need to do is when the user enters in the three letter code the form automatically puts the city in based on a table I have that has the codes and cities that go with the codes. Any help would be appreciated.

 

[Sohaila Taravati]

Make a combo box through the wizard and make the user search the code from the combo box.

 

[TRWguy]

Small Problem

Sorry this is so long after my last post,

The people I'm working with want the City Name to show up on the table now as well as the form. Is there any way that this can be done.

Thank You for any help you can give

 

[Jerry Stoner]

Why would they ever see the table or care whats in it?
Anyway just change the bound column in the combos properties from 1 to 2 but again WHY??

 

[TRWguy]

I went to the bound column and it was already on 2 so I changed it to 1 and it only changed the box on the form to the 3 letter code but didn't effect the table.

I'm also not sure if I was totally clear on what they wanted, they want both the 3 letter code and city name to be on the form. Can this be done

Thank you if you can help

 

[Jerry Stoner]

Sorry I steered you wrong. Change the control source to CityName to put it in the table. As far as both on form only 1 will show on the combo(the bound column). Put it back to 2.
To display the other value make sure it is in the combo and use a txtBox and set its Control source to
=YourCbnoName.Column() () containing whatever column the combo shows the value
ie =YourCbnoName.Column(2)