Opening a form

[Nhubbard1214]

I need help opening a form in Access using a Visual Basic code. The form is called 'Switch' if you could help thanks.

 

[smedvid]

Docmd.OpenForm

Good way to learn is by creating a blank form, then dropping a button on the form using the wizard and stepping through the Open Form option. Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[Nhubbard1214]

I managed to figure this one out, from viewing some other codes. But how can i close a form window via a script other then by using a macro.

 

[smedvid]

Private Sub cmdClose_Click()
On Error GoTo Err_Exit_Click
DoCmd.Close

Exit_Exit_Click:
Exit Sub

Err_Exit_Click:
MsgBox Err.DESCRIPTION
Resume Exit_Exit_Click

End Sub

Again, using the Wizard to create a button will generate this code. Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/