asked on 8/30/2013

Call variable from one form to another

I'm working an application that is now requiring a little VBA. I've been away from it too long to remember the details. I need to use a variable created in one form (through the use of a command button) and recall the same variable in another form that will then insert it into a table. I've included a snippet. Very simple at this stage but I'm facin a brain freeze.

Microsoft Access

Last Comment

KDWW

9/3/2013

lludden

8/30/2013

You can stick the variable in a module, then it will be globally visible within the application.

You can also define it as a global within a form and then access it from other forms.

There are a few other ways too, but those are the easiest.

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

8/30/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

KDWW

8/30/2013

ASKER

Interesting! I'll need to experiment but looks promising.

IrogSinta

8/31/2013

I've included a snippet.

What snippet?
:-)

Hamed Nasr

8/31/2013

"form that will then insert it into a table"
If interested in the value to insert in a table, then you can pass it as OpenArgs in the OpenForm.

DoCmd.OpenForm "otherForm", acNormal, , , , , "1234"

You can use the value in otherForm:
tableValue = Me.OpenArgs

KDWW

9/3/2013

ASKER

Just what I needed! Thank you capricorn1!!