Delete from table after commit

[Tvanduzee]

Hello

In my main form of a form/subform, I have a combo box that allows selecting from a table via query.
How do I know when the record of the form is committed to the db? After Access commits the record, I then need to go back to the table and remove the valued that was dropped down in the combobox.
This is only a temporary holding table for available values. Once the value is used and put into the permenant table, I need to remove that value from the temp table.

So, how can I find out when the record is committed? Because I know users can simply quit in the middle of filling in a record.


Before removing the value from the temp table, I have to be "sure" the value is going to be in the permanent table before removing from the temp table.

Thank You
Terry

[June7]

You could run a DLookup on the table.

How are users quitting the data entry? Record entry/edit is committed to table when form closes, move to new record, or run code. Unless users hit ESC key couple of times, any edits they did will be saved, or there is a custom CANCEL button on form that will undo entry/edits before form closes.

[Tvanduzee]

When users are done, they click the "Done" button, which runs a macro to save the entry, then runs a function to remove the Work Order number from the temp table. But, as you mentioned, if they hit escape the entry is cancelled, but will the Work Order number be entered into the permanent table?

Can you point me to info on customizing a cancel event to rollback any changes?

Thanks
Terry

[June7]

If you use code to populate the WorkOrder number field, not sure ESC or Undo will remove the value from the field. Would have to do some testing. Here is sample code from my project. Sending ESC is not supposed to be best method but I was not succeeding with Undo action.

Private Sub btnCancel_Click()
If Me.OpenArgs Like "Edit*" Then
    SendKeys "{ESC}", True
    SendKeys "{ESC}", True
    DoCmd.Close acForm, Me.Name, acSaveNo
Else
    Call ViewData("Quit")
End If
End Sub