code not being run in the on-close of a form

[tziviak2]

I have code-that opens a report as long as there is data in the tbl. when the user closes the report-a boolean is set to false-so that way it'll signal for the code to continue-but I close the report-and the code is still waiting for the boolean to be changed-it never stops at the on-close of the report. here's the code:

rptatt = True

    stDocName = "rptAttendanceRecord"
    
    stLinkCriteria = "[barcode]=" & Barcode
    DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria
    
  While rptatt = True
  DoEvents
  Wend

and at the onclose of the report:

 rptatt=false

but it never gets set to false-I even tracked it-and doesn't stop in the on-close any ideas why?

 

[traingamer]

Is it a global variable?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[missinglinq]

tziviak2, you should never start a new thread on an open posting. New people joining in don't know what's already been offered/tried and will waste time, yours and theirs. This thread is still on the current page of the forum:

http://www.tek-tips.com/viewthread.cfm?qid=1280585&page=1

The Missinglinq

There's ALWAYS more than one way to skin a cat!