prompt for a question with in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top