Combo Box:Populating multiple fields using Column Notation

[CharlieT302]

Hi folks,

I have a combo box that is used to populate a <City> field with a predetermined list of cities. The table that the combo box uses to obtain its values actually stores three fields: City, County, and City_Side

*City_Side indicates East Side or West Side of the metropolitan area).

When a city is chosen with the combo box, it populates the City field on the form. I also want it to populate the County and City_Side fields. I use the following code on the combo box's "After Update" property.

Me!County = Me!CitySearch.Column(1)
Me!City_Side = Me!CitySearch.Column(2)

The Row Source property lists the fields in the following order: City, County, City_Side.

<City> is the Control Source for the combo box, which is why it is not listed in the column notation listed above. The County field populates just fine. I cannot get the City_Side to populate.

I had this happen to me on another form as well. Coincidentally, in both forms, it was the last field (in the column notation) that would not populate. What would cause this?

 

[Remou]

Have you set the Column Count property (Format tag) to 3?

 

[CharlieT302]

I should have known that. Simple answer to an annoying problem. Thank you very much.