I've had an Add new record form for some time on my database but I've noticed some pitfalls of a form with it's fields bound to the table it's adding to. There is some vba code to do lookups and make sure there's no duplicates ( as well as the underlying fields no duplicate property ) validation rules set, input masks etc and other date calculations done to get the correct input from the user. Fields have to be filled in in a certain order so conditional formatting wrt "enable" is employed.

  You still get the odd time it'll save via the inbuilt functions before you hit the save button or if the form refreshes for any reason.
  I'm trying to change it to an unbound form and making an append query to add the new record so there is complete control over when a record is saved.

  I just wondered if this is the best way to go about it?