Form won't display all data

[cbwestrunner]

Hi,



I have a database with around 9300 entries and I'm trying to make a form to look up info in the database. I created the form, but for whatever reason it won't display info from all 9300 entries. Rather, it only will pull in info from 2600 or so. Here's a picture from the bottom of the form:



I can't search through all 9300 entries, just those. I have no idea why. I have three tables linked together in a relationship, but that shouldn't have any effect on it should it?

Any help would be much appreciated!

[pbaldy]

If the form is based on a query, how many records does the query return? If the form is opened via code, what's the code? What's the filter property of the form?

[cbwestrunner]

If the form is based on a query, how many records does the query return? If the form is opened via code, what's the code? What's the filter property of the form?

It's not based on a query. To be completely honest, I don't know what it's based on. Creating and running a simple SELECT * FROM EXAMPLEDATABASE shows all the records. There are no filters- I've repeatedly checked/cleared all filters.

As for code, there's literally nothing appended to anything anywhere. It's rather bizarre.

[pbaldy]

See what the Record Source property of the form is; that will tell you what it's based on. To be honest, you may not want a form opening with that many records anyway; it might be slow.