disparity between data table and form

S

Sara

I have a database containing a number of reports that are catalogued by
report category, author, year, etc. I have created a simple form for
entering these data, which is all entered into a single data table. The
problem is that after reaching a document number of 1050, the reports no
longer appear in the form view. I can open the data table and see all of
them (over 1070 now), so I know the reports and data were entered and saved,
but I need them to appear in the form as well. What is the problem and how
do I fix the disparity. Is there a limit to how many reports can be accessed
from a form?
 
A

Allen Browne

What is the RecordSource property of the form? If it is a query (not the
table), check the query's criteria to see if it is excluding some records.
Also check that no filter is being applied to the form.

Once the basics are checked, the most likely cause of the problem is a
corrupt index. This is usually solved by a repair:
Tools | Database Utilities | Compact and Repair.

If the simple repair does not work trh the steps for the 2nd symptom in:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
Top