I have an 'authorise later' command button in a 'Create Coordinator' form.
Sub Authorise_later_click()
DoCmd.Close acForm, Me.Name, acSaveNo
End sub
The problem is if the current record violates the field settings it neither show the error message nor save the record.

How to explicitly force to form to updates the last record before closing the form?