Recent content by KellyJ

David, I believe you have solved this puzzle. The code behind a Close command button on the form does include DoCmd.Close, but without any option specified, so acSavePrompt is the default. > If you're using that code, you should change acSavePrompt to acSaveNo, which explicitly discards...

Following my last post, and for comparison, I repeated this test with another form, which is similar in complexity, but does not exibit the "save changes?" prompt problem. This time, all the Guids were again different, so that may be normal every time a file is saved. The form's Left, Top...

David (Fenton), Thanks for your suggestion, and this is the result. I called the problem form "frmName" below: Open database with only switchboard opened Open Immediate window (Ctrl+G) Save form frmName as text to c:\frmName.txt Open frmName in Form view, then switch to Design view Save...

I may have given the impression that there is a live user connected to the database back end, when I said "The problem does not apparently affect the database user". What I mean is that when using the database as a user would (i.e. no access to Design mode) it does not exhibit the problem, so it...

David, Thanks for the suggestion. I imported the offending form into a new database and linked to the relevant back-end tables. The problem is still there. One other observation. If I open the form in Design mode initially, it closes ok without prompting. I only get the prompt to save...

One form in an Access 2000 format database has begun to show unexplained behaviour, whether opened in Access 2000 or 2003. When I open the form (only Form view allowed), then switch to Design view, and then immediately close the form without making any changes, Access prompts: “Do you want...