List box not populating fully.

[Ryan]

Hi all,

I have encountered a very strange problem on one of my
list boxes. When I open the form it is on, the listbox
populates correctly based on the query source. One of the
parameters in the query is a combo box on the same form
which is used as a filter by means of the after update
event and list box's requery method.

Although it is correct when the form first opens, each
subsequent requery only populates the listbox until the
bottom of the listbox is reached then stops. ie - where
it should keep populating (thus requiring a scrollbar), it
doesn't.

Any ideas?

Thanks,
Ryan

 

[Bruce Loving]

how are you changing the listbox in the afterupdate event?
are you doing anything with Filters?

 

[Ryan]

Yes ... this is how it works:

Combo boxes are used to set the filter parameters. When
any of the combo boxes are changed, the afterupdate event
of the combo box activates the listbox.requery. The list
box is based on a query that uses the value of the combo
boxes as criteria for filtering. Note: I am not using
the filter property of the form in any way. Just the
WHERE clause in the SQL.

I have programmed other listbox controls in the db in a
similar fashion ... this is the first time the list box
has behaved poorly.