List box troubles

  • Thread starter Thread starter jacqui
  • Start date Start date
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!
 
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
 
Back
Top