I've got a list box whose RowSource is a fairly complex SQL statement.



Whilst doing a demonstration yesterday, I noticed that it was only 

returning 25 rows of data, rather than 36 rows.



Checking the code today, the listbox works perfectly if you step through 

the code, and sometimes works if you run it, but sometimes returns only 

a partial recordset.



Has anyone come across this before?



-BDS

try using docmd.refresh and see what happens.

Harpreet