Problem with RowSource in Combo box

[Ross Crawford]

I have a form with an un-bound combo box. The RowSourceType is set to
TABLE/QUERY.

My query returns 4 columns, and in the query editor the correct values are
returned. However when the form is running, one column returns NULL for all
rows, when all rows contain data. I want to bind the combo value to this
column, but I can't because all the values are (incorrectly) NULL.

I've tried changing the order of the columns, and heaps of other things to
no avail. Msgboxing the values in afterupdate event
IsNull(control.column(x)) returns true, for all rows, but only for that
column.

Has anyone come across this before? Does anyone know why it is happening?

Thanks

ROSCO

 

[Joe Fallon]

Never saw it.
Sounds like a problem with your query.

 

[Marshall Barton]

I have a form with an un-bound combo box. The RowSourceType is set to
TABLE/QUERY.

My query returns 4 columns, and in the query editor the correct values are
returned. However when the form is running, one column returns NULL for all
rows, when all rows contain data. I want to bind the combo value to this
column, but I can't because all the values are (incorrectly) NULL.

I've tried changing the order of the columns, and heaps of other things to
no avail. Msgboxing the values in afterupdate event
IsNull(control.column(x)) returns true, for all rows, but only for that
column.

The only time I've seen strange behavior in a combo box is
when I had the wrong number of columns set in the combo's
property sheet. Check to make sure the property is set tto
4 and not some other number.

 

[Ross Crawford]

The only time I've seen strange behavior in a combo box is
when I had the wrong number of columns set in the combo's
property sheet. Check to make sure the property is set tto
4 and not some other number.

Thanks Marsh, but I already checked that. I haven't been able to solve the
problem but I've found a workaround.

ROSCO