Command Button Usage Only

[JoeM]

That is where the Delete command we commented out comes in to play. So we want to uncomment it.



I was playing around with it, and this order seems to have the nicest results:

Private Sub Command18_Click()

'   Add new record
    Me.Refresh
    DoCmd.SetWarnings False
    DoCmd.OpenQuery "TempCustQuery", acViewNormal, acEdit
    MsgBox (Me.TempCustName & " has been entered as a new company.")

'   Then delete it from the temp table and form
    DoCmd.RunSQL "Delete [tblTemporaryCustomer].* From [tblTemporaryCustomer];"
    Me.Requery
    DoCmd.SetWarnings True
    

End Sub

Without the "Requery" line, all the fields would show as "#DELETED" on the Form.

[dylcon]

The only existing problem with this is:
If a user enters a company name, hits tab, then closes the form, upon opening it again, it will show "#DELETED". Should I just add a requery line in the event of opening the form?

[JoeM]

If a user enters a company name, hits tab, then closes the form, upon opening it again, it will show "#DELETED". Should I just add a requery line in the event of opening the form?

One way to find out, give it a try and see if it works (programming is a lot of "trial and error"!).