A97 ComboBox Scroll Limit Is Last Selected Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kahuna - 17 Jul 2007 18:47 GMT

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!

Signature

Kahuna
------------

Reply to this Message

Douglas J. Steele - 17 Jul 2007 19:07 GMT

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?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi Folks - this is weird - heard about others having refresh problems with
> a combo but never experienced this until now.
[quoted text clipped - 13 lines]
>
> Any suggestions gratefully received!

Reply to this Message

Kahuna - 17 Jul 2007 21:14 GMT

> 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?

Yep definately sure Douglas, any suggestions?

Signature

Kahuna
------------

>> Hi Folks - this is weird - heard about others having refresh problems
>> with a combo but never experienced this until now.
[quoted text clipped - 13 lines]
>>
>> Any suggestions gratefully received!

Reply to this Message

Marshall Barton - 17 Jul 2007 21:23 GMT

>Hi Folks - this is weird - heard about others having refresh problems with a
>combo but never experienced this until now.
[quoted text clipped - 10 lines]
>The scroll bar then appears to have scrolled through the entire table but
>its hasn't!!

Is it possible that the list has not completely loaded yet?
Try adding:
x = Me.combobox.ListCount
to the form's Load event procedure.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Kahuna - 17 Jul 2007 22:12 GMT

I do believe you fixed it Marshall - Many thanks!

Signature

Kahuna
------------

>
>>Hi Folks - this is weird - heard about others having refresh problems with
[quoted text clipped - 20 lines]
> x = Me.combobox.ListCount
> to the form's Load event procedure.

Reply to this Message

Kahuna - 17 Jul 2007 22:30 GMT

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??

Signature

Kahuna
------------

>I do believe you fixed it Marshall - Many thanks!
>
[quoted text clipped - 23 lines]
>> x = Me.combobox.ListCount
>> to the form's Load event procedure.

Reply to this Message