Using Variables and/or Macros and/or VBA?

[mrmims]

Hi y'all,

I have a frm_Axes and a frm_Serial_Numbers.

In frm_Axes there is a cbo_SerNum to assign a Serial Number to an Axis. I have code so when cbo_SerNum is 2x-clicked, it opens frm_Serial_Numbers to the specified record.

This is what I want to happen, it seems easy, but I can't figure it out. When cbo_SerNum is 2x-Clicked, I want to save the Serial Number as variable SerNumReturn and then open continue with code to open frm_Serial_Numbers to the specified record. When frm_Serial_Numbers is closed, if variable SerNumReturn is defined, open frm_Axes go to a certain record, if it is not defined, then go to another form.

Basically, I want to go back to the last record open in frm_Axes after 2x-clicking cbo_SerNum.

Thank you for any and all help!

[ItsMe]

You could store your variable in a global variable that resides in a Standard Module. Another option might be to pass it in Open Args, as described here
http://www.baldyweb.com/OpenArgs.htm

Another thing you can do is use a hidden unbound textbox in the first form and store the value there.