prompt for a question with in a report

[ToniS]

I would like to prompt for "Validate Data" If the user answers Yes, The
report will check to see if all important information exists, if not, the
backcolor will be set to Grey, if all data exists, the backcolor will be set
to White. I do all of the data checking with in the Detail_Format event..
The problem I am having is how to prompt the user? I am used to doing this
for an .MDB, but apparently that is different for an .ADP (which this report
is) I would like to do this with out creating a form to prompt the user,
maybe that is not possible?


Any help will be greatly appreciated
ToniS

 

[GerMil]

Hi ToniS,

Why don't you put the question to the user before opening the report by
using a MsgBox and send the answer along in the OpenArgs of the report while
opening it?

If MsgBox("Prompt",vbYesNo+vbDefaultButton1+vbQuestion,"Title")=vbYes Then
'Send value 1
Else
'Send value 0
End If


GerMil

 

[ToniS]

That is perfect!!!! Thank you so much for the quick response!!!

Thanks again!
ToniS