Requery Not Fast Enough?

[Geoffrey.Bakker]

I have a combo box linked to a query which returns results based on the
criteria provided in the combo box. Also, I have a listbox to display
the queried information. Both the Combo box and List box are displayed
on the same form. However, my issue is that when I requery the listbox
using the AfterUpdate field in the combo box, when I'm returned a large
number of results the list box only shows 1 or 2 records. Is there
anything I can do to help this situation? Let me know if I need to
include any more information.

Geoffrey

 

[Damian S]

Hi Geoffrey,

Have you run your query on its own to confirm that it is returning the
correct number of records (when your listbox only shows 2 records).

Also, and I know it seems silly, do you have your listbox height more than 2
records high and a vertical scrollbar switched on?

Damian.

 

[Geoffrey.Bakker]

Damian,

Thanks for the reply. It seems that when i run the query itself to
test it also only returns 2 values occasionally. Also, the list box
height is adequate and both scroll bars are switched on. Any thoughts
on why this might be happening? Thanks

Geoffrey