Cancel = true

[Stapes]

Hi

I am attempting to run the following: -

Dim stDocName As String

stDocName = "KPI Data - New links to PEOPLE table"
DoCmd.OpenReport stDocName, acPreview
stDocName = "KPI Data - New ATTEND Records"
DoCmd.OpenReport stDocName, acPreview

Each report has the On No Data property set, displays a message, then
sets Cancel = True.
However, it appears it doesn't do anything else after Cancel is set to
True in the first report. It does not even try to open the second
report. I guess this is because Cancel is set to True. How can I unset
this - if that is the case?

Stapes

 

[Allen Browne]

Answered in your post 3 minutes later