Problem with RowSource in Combo box

  • Thread starter Thread starter Ross Crawford
  • Start date Start date
R

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
 
Ross said:
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.
Click to expand...


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.
 
Marshall Barton said:
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.
Click to expand...

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

ROSCO
 
Back
Top