passing a variable from one form to another

[habbabub]

how can i pass a variable from one form to another

this works fine
Tracking_Number = Forms("Main").Control("mytext")

but if "mytext" was in vb (rather than from a text box as shown above) how can i do this

 

[Guus2005]

A form is a class. If you create Let and Get variables it will work. Also a global variable will work. There are several more ways to do this. Try these first.

Enjoy!

 

[boblarson]

how can i pass a variable from one form to another

this works fine
Tracking_Number = Forms("Main").Control("mytext")

but if "mytext" was in vb (rather than from a text box as shown above) how can i do this

And to expand on GUUS2005's answer -

If mytext was a variable (and in scope) then you could use

Tracking_Number = mytext

 

[durexlw]

Another option is to use the openargs of the openform command. I remember doing that somewhere in the past.
If you need to pass multiple parameters, write a little parser for it.

Here's a guy who typed it out for me:
http://www.codeproject.com/KB/vb/passvaluetoaccessform.aspx

 

[durexlw]

By the way, if you're on Access2007, check out the new feature: TempVars

It's a collection that lives as long as your DB is open, across forms and whatever... simple to use:

To store a value:
TempVars.Add "CustomerId", Me.CustomerId

To get it back:
sTemp = TempVars![CustomerId]

In the northwind, you'll find samples of it.