How is this happening?

[cdoyle]

Hi,

I have a main form, with a sub form.

The sub form is where the users enter their data. I have it set so it opens with a blank form, and doesn't show any past data. It will only show records based on the current session.

I also have the filter properties set to no.

I have one user, that is somehow while entering data. The form will go back to showing all data for their ID.

She has to close the form, and reopen and it works again.

Any ideas, a setting or something that I'm missing?

 

[cdoyle]

OK, it just happened to me now.
I had the db open in the background and have been working on something else.
I just went back to the db, and the record navigator was showing 1 of 24 records, which is all the records under my id. I shouldn't be showing any, since I haven't entered anything yet since opening the form.

I've never seen this before.

 

[cdoyle]

Does anyone have any ideas to why it's doing this?
It just did it to me again, I've had it open in the background for about 30 minutes, just went back to it, and the subform is showing older entries again.

I have my subform setup like this
allow filters: no
allow deletions: no
data entry: no

the only vba I have on the form is this
Forms!main_entry_FRM![Todays_Activity_FRM].Form.Requery

This just updates another subform.

I need to have it so it doesn't ever show older records