Close a form

Hello,

I'm a real, real dummy in VB.

VB Code:

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.

you can Unload a form

Mike

formname.Unload

Access VBA question moved to Office Development

Or there is always

VB Code:

Me.Hide

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

VB Code:

Me.Show

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

VB Code:

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

:)