I have a Form1 that user can input ship_id and ship_date. Upon the clicking on "OK", those inputs were inserted into Table1. This works fine. But the Form1 stays open. How can I close the Form1 when users click on "OK" and records are inserted at the same time?
Private Sub cmdAddNew_Click()
On Error GoTo Err_cmdAddNew_Click
DoCmd.GoToRecord , , acNewRec