Limit records Access 2007

[spendy]

Hello,

I am using Access 2007 and i have this table, Orders, which contains more than 1000 records. I can see all the records in the table, but in the attached form i can see only 999 records. I have changed the option in the Database Tools to show 99999 records, but still I won't see these records over 999 in the attached form.

I have to say that the Record Source for the form does only select all the records in the table, so I'm pretty sure that cannot be the cause that limits displaying records after 999.


On the other hand, I have another table, called Invoices. In this table, again, I have over 1000 records, but in the attached form I get to see the Invoice starting 1000 as a FIRST record. When I hit the "First Record" button in the navigation panel, I get to see the invoice starting 1000.


So, I would be very grateful if anyone could help me with this problem, as I don't see the bottom of it, no matter how much I tried. The primary keys in both tables are Autonumber, if that's helpful.


Thank you in advance,
Sandra

[ItsMe]

If you have a bound form, the form will have access to all the records in the Query or Table it is bound to. Perhaps the form's Filter property is limiting the records retrieved from the table. You can view the Filter property in the Property Sheet under the Data tab while in Design View of your form.