HOW CAN I SET A "SWITCH" ON A FORM TO FORCE USER TO PERFORM AN ACTION

[Paul7905]

I HAVE A FORM IN WHICH USERS ENTER TEMPORARY DATA INTO A TABLE.&nbsp;&nbsp;WHEN THEY EXIT THE FORM, I HAVE CODE THAT INVOKES A QUERY THAT WILL &quot;ZERO&quot; OUT THE ENTRIES THAT THEY HAVE MADE.&nbsp;&nbsp;BEFORE THEY EXIT THE FORM HOWEVER, THEY MUST PRINT A REPORT (WHICH IS INVOKED BY ANOTHER BUTTON ON THE FORM).&nbsp;&nbsp;I AM LOOKING FOR A WAY TO FORCE THE USER TO PRINT THE REPORT BEFORE EXITING THE FORM.&nbsp;&nbsp;I WAS THINKING THAT THE PRINT FUNCTION COULD SET A &quot;SWITCH&quot; TO A VALUE WHEN THE REPORT IS PRINTED; THE SWITCH COULD BE INTERROGATED FOR THAT VALUE IN THE EXIT CODE AND IF IT IS NOT SET, FORCE THE USER BACK TO THE FORM WITH A MESSAGE BOX.&nbsp;&nbsp;IS THIS FEASABLE AND DOES ANYONE HAVE IDEAS ON HOW I CAN DO THIS OR SOMETHING SIMILAR?&nbsp;&nbsp;(I THOUGHT ABOUT PRINTING THE REPORT AUTOMATICALLY IN THE EXIT ROUTINE BUT THIS IS NOT FEASABLE FOR REASONS I WON'T GO INTO HERE)<br><br>THANKS ~&nbsp;&nbsp;<br><br>PAUL

 

[Guest_imported]

just a thought<br><br>in forms declatations sections place code<br>public toggle as string<br><br>in the forms on load or perhaps update event place code<br>toggle = &quot;ON&quot;<br><br>on the button they must push to print the report<br>place in the on click event<br>toggle = &quot;OFF&quot;<br><br>in the forms unload event place code<br><br>if toggle = &quot;ON&quot; then <br>msgbox &quot; Print report First&quot;<br>docmd.cancelevent<br>end if

 

[Chopper]

Instead of bothering with a switch, why don't you disable the exit button.&nbsp;&nbsp;Then, when the report has printed, enable the exit button as in: me.cmdExit.enabled = true&nbsp;&nbsp;Of course, you will need to set the form's close button to 'no' on the properties. <p>-Chopper<br><a href=mailto: > </a><br><a href= > </a><br>

 

[jimmythegeek]

I agree with chopper.<br><br>You could also just automatically print the report on close of the form, and not even prompt the user. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development