Thanks all for the support - in the end i added 1 field from my sub form, to my main form, then added the dirty = false code.
Warning - I'm going to ask a very insulting question - Did you test this before distributing the new FE? If so, does that FE still work?
Also, NEVER just force a record to save to get around a stupid problem. You are saving empty records which itself should be an error.
The picture you displayed shows the subform as dirty. A form should NEVER open as dirty. What is your code doing to dirty the record? You should not have code in the open/load/current event that dirties a record. PERIOD.
You should ALWAYS have a minimum of two databases. The production database where the users enter production data and a test database where you test new code. And in reality, you almost always need at least THREE versions of a database. The middle version is generally referred to as QA (quality assurance) or user testing and you ALWAYS move from test (where you have thoroughly tested everything) to QA where the user gets to do testing. Once the users are happy with how the app works in QA, THEN and only then would you move to the production environment.
One of my clients, who did work for the armed forces, had EIGHT staging environments prior to the final move to production and the app had to go through testing each time it got promoted to the next level.
Hi Pat, good advice as always,
This change was in a test version, i currently have 4 different versions (Main, Test, Admin and Archive - (And backups of each every 2 hours).
The Main version is linking back into a Access back end.
I have now resolved the issue aboe by moving 1 field from my subform to the main form - and then adding the Dirty code.
I will make live tomorrow and then leave alone for a couple of days, to iron out any bugs and then next week move another group of tables into SQL, In total i think i have about 40 different tables to move.
On the Screenshot above - i had selected a contract - which Dirtied the form