Cannot get a control to populate based on dropdown control selection

[mmethe]

Hello all,



I have a combo box on a form that is based upon a query. When a selection is made several unbound controls display information drawn from the dropdown box. Several of these unbound controls work fine, a couple dont and I am stumped as to why. Here is an example:



The dropdown is named: cmbo_dest
Its source is: SELECT qry_destinations_asc.dst_id, qry_destinations_asc.dst_name, qry_destinations_asc.dst_department, qry_destinations_asc.dst_city, qry_destinations_asc.dst_phone, qry_destinations_asc.dst_street, qry_destinations_asc.dst_state FROM qry_destinations_asc;

The text box name has a source of: =[cmbo_dest].[Column](1)
That text box works fine, as does Department, City and Phone

I cannot get State (the un-named control) to populate

If I run the SQL I get:


So I know state is populated.

Why cant I get state to show up? If I throw a msgbox in, I am told that [cmbo_dest].[Column](6) is NULL. The query underlying show data in the state field.

Thank You!!!!

[June7]

What is combobox ColumnCount property? Should be 7.

[Micron]

You likely are out of sync as is being suggested, but I'd advise to drop the [ ] around Column as a matter of good habit. They are for encapsulating a field name, especially if it contains spaces. Column is also a reserved word for an Access property, so don't use it for any user defined name either.

[June7]

It is Column property referenced in the expression. Access automatically adds the [ ] around Column property.

[mmethe]

What is combobox ColumnCount property? Should be 7.

You nailed it! Thank You!