Control isn't updating

Topic

New Reply

Hi,
I’m attaching a strippeddown version of a database. [zip] and [state] should update when cmbCity is completed. [state] is working fine, but not [zip] and I’m not sure why.

Thanks!
Leesha

Reply | Quote

Replies

It appears that your cmbCity only has one column, which means even though your Row Source has multiple columns, you can’t reference them. It seems you code should actually throw an error when it tries to execute the statement Me.Zip=Me.cmbCity.Column(2) in the AfterUpdate event of the combo box. Also I should note that most cities of any significant size have multiple ZIP codes….

Reply | Quote

Hi,
I’m attaching a strippeddown version of a database. [zip] and [state] should update when cmbCity is completed. [state] is working fine, but not [zip] and I’m not sure why.

Thanks!
Leesha

Your combo has only 1 column so I am surprised that state is working. give it 3 columns and it will work.

Reply | Quote

Thanks to both of you! I can’t believe I missed that. I guess I was too tired to see the forrest for the trees.

Thanks,
Leesha

Reply | Quote