linking fields on a form

[erich13us]

I have a form that uses City, State and Zip Code as Combo boxes. They all use the same lookup table. After I enter the city, I want the corresponding Zip Code to be entered in the ZipCode Field.

 

[Trendsetter]

In the query that populates the "City" combo have the state and zip fields as columns 3 & 4.
After you have selected city in the After_Update event of the combo write:

Me.ComboState = Me.ComboCity.Column(2)
Me.ComboZip = Me.ComboCity.Column(3)

The count for columns in a combo starts from zero!

 

[erich13us]

I can't get it to work. The data is coming from a table not a query. Would that be the cause? The columns in the table are City, State, Zip and CS Cachment. Also, it dosen't seem to like the use of the word "combo".

Erich

 

[Trendsetter]

Using a table doesn't change the situation but you lose some of the facilities of sorting etc...

The expression Me.ComboState is meant to refer to the name of the combo in which you want the State data - this could be Me.Item26 or whatever - you need to look in the proerty page to find the name of the control.........this applies to all of the controls referred to:
.....State
.....City
.....Zip

 

[Rolliee]

send me your email and I will send you a sample of how to do what you wish.

rollie@bwsys.net