yes/ no message box

[11am]

im new to access and havin trouble with this problem though i have used visual basic for a while i have the following code to close a form down. in vb the red code would be used to create the yes no msg box but when i compile it is fine then when i use the button it isnt accepted the red coding bit. any help with what im doing worng would be appreciated.


Private Sub Command28_Click()

On Error GoTo Err_Command28_Click

If (MessageBox.Show("Are you sure you want to exit?", "EXIT?", _
MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = DialogResult.Yes) Then

DoCmd.Close

Exit_Command28_Click:
Exit Sub

Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click


End Sub

 

[KenHigg]

if msgbox("Are you sure you want to exit?", vbYesNo,"Exit") = vbYes then docmd.close

(I think I have this correct )

 

[11am]

works fine thanks

 

[Mile-O]

THe code you originally had is VB.NET and not VBA.

 

[KenHigg]

You're doing VB.Net stuff now SJ?

 

[tkpstock]

Isn't MSO VBA for 2003 supposed to be on a .NET type architecture? That's what I thought...?

I'm still on 2002, so I don't know.

 

[Mile-O]

You're doing VB.Net stuff now SJ?

Just started.

 

[KenHigg]

I've got videos for that as well - but I haven't had time to go through them...

Did the others help?

 

[Mile-O]

Did the others help?

The ones that I've watched thus far have helped. Think I've watched about 20 of them.