Close a form

[IwanVerrips]

Hello,

I'm a real, real dummy in VB.

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click
 
 
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
 
Exit_Command28_Click:
    Exit Sub
 
Err_Command28_Click:
    MsgBox Err.Description
    Resume Exit_Command28_Click
    
End Sub

How do I get the the forum closed after the saving?

Greetings,
Iwan.

[MikeJoel]

you can Unload a form

Mike

[Christopher_Arm]

formname.Unload

[Hack]

Access VBA question moved to Office Development

[the182guy]

Or there is always

Me.Hide

This will keep the form in memory if you need to load it back up use

Me.Show

Me will call the form which the code is embedded in.

[RobDog888]

Application.DoCmd.Close acForm, "Form1", acSaveNo