Can some one provide me VBA codes to make the warning dialog box popout?

[accessbeginner]

Hi,
Does anyone know how to insert a warning message (make a warning message dialog box displays also) so the user can be aware when he/she selects “CLOSED” from the Status combo box that the form will not be editable once the current is saved/close or if there is a new record is added? (I would like to have a YES and NO button on the dialog box also.)

The warning message should be like this:

This form will not be editable after you save, close or add a new record. Do you want to continue?



Thank you for your help!

Below are the VBA codes I have used. If you have any other codes better than mine, please feel free to let me know. Thanks

Private Sub Form_AfterUpdate()
If Me![STATUS] = "CLOSED" Then
    Me.AllowEdits = False
    Else
    Me.AllowEdits = True
End If

End Sub



Private Sub Form_Current()
If Me![STATUS] = "CLOSED" Then
    Me.AllowEdits = False
    Else
    Me.AllowEdits = True
End If

End Sub

[jimatqsi]

ab,
What you want is the MsgBox function. Take a look at it. You'll call it something like this:

if msgbox ("Hey there user, did you know that ...",vbYesNo)=vbYes then ... do stuff
else
   don't do stuff
end if

[zmbd]

here's the link:
MsgBox Function (ACC2007 but it hasn't changed since ACC2003)

[accessbeginner]

Hi zmbd and jimatqsi,
I know that I need to have VBA code for this but I am absolutely don't know anything about how to write it and where to insert it. Could you please kindly provide me a VBA code and show me where to insert it?
Thanks

[zmbd]

What I can and will do is PM you a basic set of tutorials and reference links. Please check your Bytes.com Inbox.

You absolutely must master the first tutorial in this set before you can hope to get anything useful out of Access and benifit from the help we can give you here, or indeed, in any Access website.