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?

On Wed, 16 Jul 2003 06:45:19 -0700, "Ryan" <kalsonik@hotmail.com>
wrote:

>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

[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.

>-----Original Message-----
>how are you changing the listbox in the afterupdate

event?

>are you doing anything with Filters?
>
>On Wed, 16 Jul 2003 06:45:19 -0700, "Ryan"

<kalsonik@hotmail.com>

>wrote:
>

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

>
>.
>