p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

access thread: Why is my list box not returning all it's rows?

Message #1 by Brian Skelton <brian.skelton@b...> on Wed, 13 Jun 2001 18:26:37 +0100
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?


Message #2 by SinghToor@a... on Wed, 13 Jun 2001 13:54:03 EDT
try using docmd.refresh and see what happens.


  Return to Index