IF Question

[Sadukar]

Hi All,
Cant figure this out!

If a verification box is checked then I want to ask if "you want to Print again"
I want a yes or no, yes being print again and no being end. (Ie yes goes to Else)
I need the print code after ELSE so I can print report as normal if they are not checked off as printed.

If Me.Verificationbox.Value = "-1" Then
MsgBox "Already printed! Do you want to print again?" (What do I do here?)
Else
DoCmd.OpenReport ReportName, acPreview

How do I do this?

I would appreciate any suggestions.

Thanks
S.

 

[DJS2]

Try

If Me.Verificationbox.Value = -1 Then

If MsgBox("Already printed!" & chr(10) & "Do you want to print again?&quot=vbYes then
DoCmd.OpenReport ReportName, acViewNormal
End If

Else
DoCmd.OpenReport ReportName, acPreview
End If

 

[Sadukar]

Thanks DJS2
Exactly what I wanted.
Except:
You forgot , vbYesNo at the end.
EG: If MsgBox("Already printed!" & chr(10) & "Do you want to print again?", vbYesNo)=vbYes then

Not trying to be critical just adding it in case anyone else is going to look up post in future.

thanks for help
S.