prompt

[Gruung]

I know this is probably a really stupid question, i need to know the code for a prompt. I want it so that when a user presses a button it prompts the user saying are you sure you want to do this and if they click yes then carry out the action.

Thanks

 

[Douglas J. Steele]

Try the MsgBox function.

If MsgBox("Are you sure you want to do this?", _
vbQuestion + vbYesNo + vbDefaultButton1) _
= vbYes Then
' continue with the action
End If

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I know this is probably a really stupid question, i need to know the code

for a prompt. I want it so that when a user presses a button it prompts the
user saying are you sure you want to do this and if they click yes then
carry out the action.