New records not appearing in report

[snu]

I have been using a form to enter data for over a year now and it always populates a report. For some reason for the first time ever today when I added a new record it failed to appear in the report. I tried refreshing, hitting back and forward in the form, adding an additional record to see if that would work. Nothing works. It seems like my report is acting as if it is "full" (there are only 70 records). Any ideas what could be going on? Is this some bug?

 

[snu]

BTW my other reports and forms are working fine. It's just this one.

 

[boblarson]

Sounds like there is a persistent filter for some reason on it. Which version of Access are you using?

 

[snu]

2007

Could the filter just turn on like that?

 

[boblarson]

2007

Could the filter just turn on like that?

As a matter of fact, there is a newer property in 2007 for a form which is FILTER ON LOAD. Check to see if it might be set to YES instead of NO.

 

[snu]

It's set to NO.

 

[snu]

Order By On Load is set to YES though if that means anything.

 

[snu]

What about Allow Filters that is set to YES

Also I checked the table and the data is showing up there.