I have an access database which has started to produce an error. On the machines form of the attached database, it audits any changes you make. It does this by calling a function from the BeforeUpdate event of the form, which then opens another form asking for more detail and giving the option to cancel the change.
In certain conditions a dialogue box appears stating the the BeforeUpdate property is preventing the field from being saved (I have attached a screen print of the actual error). So far my findings are:-
1. If you make a change to the Machine Information (top of the machines form) and press CTRL+Shift to save the record, the error does not appear.
2. If you make a change to the Machine Information and click on the Finish Editing button, the error does not appear.
3. If you make a change to the Machine Information and click on one the subforms the error DOES appear.
I have used breakpoints in the code to try and trap the specific point the error is happening but the error does not appear by stepping through the code. I have however narrowed it down to being the DoEvents part of the code which is in a While loop.
As I mentioned, I have attached the database in question, you will need to open the Machines form and click on the Edit Machines Settings button to make any changes and I have been using the No CPU's field for testing.
Any help would be much appreciated.