List box not showing all records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list box on a form showing breif details of records so that the user
can choose which record they wish to look at. The user can then double click
the ietm in the list box and that record is displayed on another form.

My problem exists when opening the list box. When first opened, the list
box only shows about the first 50 records. If the user requeries the list
box, more records show up. So on and so forth.

Does anyone know why this is? How can I get my list box to show all records
without the need to requery?
 
Thanks Graham, I tried what you suggested, but it has made no difference.
I have narrowed the problem down, and I dont think it has anything to do
with the rowsource. If I open the form and click on the scroll bar to move
down, not all records show. If I use the arrow at the bottom of the scroll
bar to move down, then all records are shown. Any more suggestions?
 
Corey,

Now that IS wierd! Perhaps that instance of the control is corrupt. Try
doing this:

1. Delete the control from the form.
2. Decompile the database (if you don't know how, I can tell you).
3. Compact & Repair the database.
4. Add a new instance of the control to the form.
5. Compile the database.
6. Try again.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Pardon me, I think you made a slight error.

lReturn = cboMyCombo.ListCount

NOt ListIndex

Sorry to jump in like that.
 
I think that it is taking to long to populate the list box through our
network. IF I open the form and leave it for a couple of seconds, all
records show regardless of how I scroll through.
 
I have changed that line and now the list box appears to work fine. Thank
you all for your help. You have got a lot of people off my back.
 
Back
Top