List box troubles

J

jacqui

Hello,
Intermittently - the listbox on my form displays less
than a full set of rows - maybe related to scrolling - or
not. The rowsource is one of two querydefs, the list is
requeried on an afterupdate event of an option group.
I've already rebuilt the form thinking corruption, but
alas. The list is currently less than 100 rows.

Im stumped. Any clues much appreciated!
 
J

John Spencer (MVP)

Try assigning the Listcount property of the list to a variable. This forces the
list to rebuild all the way to the end. Sample AIRCODE (untested) follows.

Dim lngCount as Long

Me.YourListBox.Requery
lngCount = Me.YourListBox.ListCount
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

list box requery 1
list box row source 1
List Boxes Do Not Requery 5
Requery not working 8
how to make listbox automatically scroll to bottom 2
List Boxes Do Not Requery (Access 2003) 4
List Box Does Not Requery (Access 2003) 0
Synchronised Combo Boxes - Code Doesn't Work 6

Top