A97 ComboBox Scroll Limit Is Last Selected Record

  • Thread starter Thread starter Kahuna
  • Start date Start date
K

Kahuna

Hi Folks - this is weird - heard about others having refresh problems with a
combo but never experienced this until now.

Combo is on a subform: Rowsource is a table that has 600 plus records, and a
ControlSource in my main table.

The combo appears to work fine, allowing the selection of the data from the
look-up table and adding it to the ControlSource column of the main table.
The challenge is that after the first selection from the combo (say row 20
of the 600 record table) it appears to thereafter limit its drop down range
to that first record - that is the combo will display only 20 rows.

The scroll bar then appears to have scrolled through the entire table but
its hasn't!!

Any suggestions gratefully received!
 
You sure you don't have code anywhere that resets the RowSource for the
combo, or that the RowSource doesn't have a reference to some control that
limits what's returned?
 
Douglas J. Steele said:
You sure you don't have code anywhere that resets the RowSource for the
combo, or that the RowSource doesn't have a reference to some control that
limits what's returned?
Click to expand...

Yep definately sure Douglas, any suggestions?
 
Kahuna said:
Hi Folks - this is weird - heard about others having refresh problems with a
combo but never experienced this until now.

Combo is on a subform: Rowsource is a table that has 600 plus records, and a
ControlSource in my main table.

The combo appears to work fine, allowing the selection of the data from the
look-up table and adding it to the ControlSource column of the main table.
The challenge is that after the first selection from the combo (say row 20
of the 600 record table) it appears to thereafter limit its drop down range
to that first record - that is the combo will display only 20 rows.

The scroll bar then appears to have scrolled through the entire table but
its hasn't!!
Click to expand...


Is it possible that the list has not completely loaded yet?
Try adding:
x = Me.combobox.ListCount
to the form's Load event procedure.
 
Ahh - thanks for help guys but it seems there is another part to my
challenge.

I have the combo loading successfully now (thanks all), but I am loading
other text box's based on the other columns in the rowsorce for the combo -
so eg:

=[cboMatTypeDesc].[Column](5) loads the text field with data from column 5
of the combo (or 6 in fact as its 0 based) rowsource (or should).

However this is working sporadically. I have 35 or so fields being populated
in this way and many of them are simply not being read / populated from the
look-up table.

Is there a limit on how many columns there can be in the rowsource for the
combo (I am only displaying 10 - though not consecutively listed).

Is there a more elegant way to do this - I suspect DLookup would be clumsy
and time consuming during run??

--
Kahuna
------------
Kahuna said:
I do believe you fixed it Marshall - Many thanks!
Click to expand...
 
Back
Top