Forms Shutting Down

[jlgray0127]

I have a form with actions queries that run via VBA when the form closes.
If something happens and the form closes (Close database with form open, Click X (I can remove this) rather than "Exit Button", the value I need for the action queries to run, is lost and I get the pop up prompting me for the value.

Is there a way to retain that value( believe I had read this once long ago) so that no matter how the form closes, that value is available for all the action queries to run as the database is closing? Sorry, not a newbie, but drawing a blank and hoping to trigger some of my access friends thoughts on this before putting a great deal of thought in to it...
Thank you so much in advance. Swamped at work and it's taking away from love of building in Access!

[June7]

I customize db so users cannot use X close on forms or application, also disable ribbon Exit and Close, disable right click shortcut menu.

However, if you don't want to go to those extremes, try a global variable declared in a general module. The query cannot reference the variable directly but can call a function that references the variable. Real trick is figuring out where to put code that sets the variable. Also, TempVars might be an option but I have never used them. Or could save value to table and query includes that table.

[jlgray0127]

Ha! Simple! I used the table with the value stored. Thanks! If only I'd have taken a minute, it'd of been obvious! I will go for the longer term solution when I can get back to modifying this tool, as it's in a shared environment and need it to be as robust as possible! thanks, again!

[June7]

This a multi-user split db? Would several users be in db at same time and each trying to edit this value?