Access Crashing....

access7

Registered User.
Local time
Today, 16:54
Joined
Mar 15, 2011
Messages
172
Hello

I have recently changed the Data Entry property on a subform to 'Yes' (so that it will always open at a new record... I have tried DoCmd.GoToRecord,,,acnewrec on nearly every event procedure and it just isnt working... so I opted to change Data Entry to 'Yes'. This is now working exactly how I would want for my subform, i.e. each time the form loads its ready for the user to enter a new record... however - since changing this Access keeps crashing... it closes (takes a back up) and then re-starts itself... problem being it then doesnt save (even on the back up) what ever I have just done.
I'm sure everyone can relate that this is very frustrating.

I wondered whether anyone else had any experience of a similar problem or whether any knows of anything that the Data Entry Property may be conflicting with??

Any clues are very much appreciated so I can try and stop it from crashing...:eek:
 
Try to compact and repair database, also do compile debug your VBA code and see where is the mess...
 

Users who are viewing this thread

Back
Top Bottom