Link to home
Start Free TrialLog in
Avatar of kg6lfz
kg6lfz

asked on

how to close form after inserting new records

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

Exit_cmdAddNew_Click:
    Exit Sub

Err_cmdAddNew_Click:
   MsgBox Err.Description
   Resume Exit_cmdAddNew_Click

End Sub
ASKER CERTIFIED SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial