Weird Filtering Problem??

[AlienzDDS]

I have a database which has suddenly developed a weird problem.

When the user opens a form it is blank although there are many records in
the data source. This is a form which has been in production for a couple of
years. No changes have been made to it. There are no filters on it but if
you click Form Filter, do not enter any criteria, then apply filter, all the
records show up. There are no saved filters on the underlying form or in the
code. This has happened five times to different forms over the last three
weeks. One of which is in a separate FE connected to the back end and this
FE was not touched at all. Another occasion happened in the development/test
environment attached to a testing BE.

Any ideas on what is causing this and how to fix it? Was there a recent
Office update which may have caused this?

Thanks - Ali.

 

[Allen Browne]

If this is Access 2007, open the form in design view and set the
FilterOnLoad property to No.

If that's not what's going on, ask Access what's happening. Open the
Immediate Window (Ctrl+G), and ask it things like:
? Forms!Form1.Filter
? Forms!Form1.FilterOn
? Forms!Form1.RecordSource
? Forms!Form1.DataEntry

 

[AlienzDDS]

I should have mentioned that one of the times this happened it was a query
not a form. This query is in a separate front end and is auto-emailed to a
group on a scheduled task. It suddenly emailed empty the day after the
problem surfaced in the main FE.

For this reason I do not think that the form settings are relevant.

 

[Allen Browne]

I don't understand what you are doing.
Filtering a form that isn't a form, with no data, and no records show up.

Perhaps you could start a new thread explaining the question, and leave this
thred to die a natural death.