How to force a form to update?

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?

Quote:

---

Originally Posted by prabhafriend

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?

---

Try this:

Code:

---


Sub Authorise_later_click()
  ' save record if needed
  If Me.Dirty Then Me.Dirty = False

  DoCmd.Close acForm, Me.Name, acSaveNo
End sub

---