Suppressing the new record until the previous record has been completed

[Remster]

Please see MyForm in the attached sample database. As soon as you type a character in the new record (which will be ID 4), a second new record appears (which will be ID 5). I realise this is standard Access behaviour.



Is there any way of suppressing the second new record until the first new record has been completed? I've tried using the form's On Dirty event to set AllowAdditions to 'False', but this simply removes the first new record.

MyDatabase.accdb

[davegri]

FruitColor-davegri-v02.zip

You could have an unbound form and use insert SQL to create the record.

[Missinglinq]

...As soon as you type a character in the new record...a second new record appears...

You have to understand that you're not actually seeing a 'new Record!' While the Access Gnomes have presented what appears to be a new Record, it's actually only framework for a new Record, if you will! It will only become a new Record if, once again, you enter a single character into one of its Controls!

To keep your user from moving to a new Record, before completing their current Record, you need to have validation, insuring that all Controls, in the current Record, are populated/saved first.

Linq ;0)>