Unanswered: DoCmd.Close acForm, formName, acSaveNo always save a record?
I have an Access form that is mapping to a SQL Sever table. The form allows users to enter data, and then click a button ADD or CANCEL. The form has a text box ID that is mapping with the primary key ID of the table student. The button ADD works OK, but the problem is the button CANCEL. If a user enters an ID, and the user clicks the CANCEL button, the VBA 'DoCmd.Close acForm, formName, acSaveNo' always save that record.