Simple Message box when opening a Form

[sparkyinak]

I have two forms that are basically identical. One is a read only form while the other used for editing database. Is there a simple VBA that will put up a yes/no Message Box up when opening the form to caution the user they are on the editable form? If yes, form opens, if no, form closes.

Writing VBA is not my strong suit

[isladogs]

Add something like this to the Form_Load event

If MsgBox("WARNING: This form is READ ONLY and data cannot be edited" & _
  vbCrLf & "Do you want to continue?", vbQuestion+vbYesNo, "Form is READ ONLY")=vbNo Then
   DoCmd.Close acForm, Me.Name
End If

[ranman256]

put a label on the forms:
the Read Only form has: READ ONLY data
the other EDIT

you know you only need 1 form to do both:
edit:
docmd.OpenForm "frmMyform"

RO:
docmd.OpenForm "frmMyform",,,,acFormReadOnly

[isladogs]

Good point. Much better solution.

[sparkyinak]

Thanx you two. It works