Populating information from combo box

[Guest]

The proper code for storing the information from a combo box.

Example: Combo has list of zip codes with associated city and state.
I need to poplute the city and state fields in a "Lost Focus Event.

Me.CompanyCity = CompanyZip.Column(1)
error: Member or data not found.

 

[Ken Snell [MVP]]

This article describes how to set up what you want to do.
http://www.mvps.org/access/forms/frm0058.htm

The error that you're getting suggests that you may have the wrong name for
the combo box, or that the combo box is named the same as a field in the
form's recordset.