forms doing strange things

[Gary B via AccessMonster.com]

Hi all,

I wonder if anyone can help me with this.

I am running Access 2002 and 2003 and have the same problem with both.

If I have created a form with a subform, every so often the form, when opened,
will stop showing anything other than a new record. Even if I open it from
the database window, it goes straight to a new record, so that I cannot
navigate to previous records (navigation buttons are on). Because of this I
have to keep constantly backing up forms within the database (apart from the
db backups), so that when it happens I can replace it with the backed up form.
The trouble is of course, every so often I get so focused on the programming
that I forget to backup for half an hour and then ...bang.... I've lost a
half hours work.

There is nothing special about these forms. Usually they have a subform with
continuous forms set. And mostly there is a DMax condition set in the
default value. I don't have any viruses or spyware. My Office installations
are up to date as is my Windows installation.

I'm getting very frustrated now, so any idea's would be very gratefully
received. My next step is to re-install Access, but I'd like to avoid that
if poss.

Thanks.

 

[Allen Browne]

Is it possible that the Data Entry property of this form is being set to
Yes, when it should be No?

 

[Gary B via AccessMonster.com]

Thanks for your reply Allen,

I did check this and the entry is as it should be. I even reset it to 'Yes'
just in case it made a difference, but it didn't.

I've tried removing the subform, just in case it is causing errors, but it
makes no difference. I've also checked all combo boxes just in case a
reference was causing a problem (it wasn't). I've even removed every field
except the ID field with no change. It seems that once the form has decided
it's not playing any more, that's it. Only replacing it with a backup will
do. If I only knew what was causing it in the first place I could get there
before it happened.

Is it possible that the Data Entry property of this form is being set to
Yes, when it should be No?

I wonder if anyone can help me with this.

[quoted text clipped - 27 lines]

that
if poss.