Always available variable 1

[aliendan]

Say I've got a form with an option group with three choices that are values 1,2 and 3. Say I choose value 2, is there any way to keep that value 2 floating around out there in the air somewhere so that it can be used by other forms or modules even if the original form is closed after choosing the value? In advance...I really appreciate your help on this one.

Thanks,
Dan

Dan Rogotzke
Daniel_Rogotzke@oxy.com

 

[PHV]

You may either use a Public variable declared in a standard code module or store the the value in a table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

You can also use [blue]Custom Db Properties![/blue]. These properties are [blue]non-volatile[/blue] and stay with the Db! ... No Table Required!

Have a look at my post here: Automated Import Not Working Properly

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[JBinQLD]

Had to give the Aceman1 a star for that because of the non-volatility of db properties. And for reminding me of something I'd forgotten about....

 

[TheAceMan1]

JBinQLD . . .

Thanks! I've found the need in most Dbs I've created . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[aliendan]

Thank you all. Closer to my understanding, I went with the use of storing the value in a table, which I have done before. Since the value used needs to be dynamic this works very well for me and the overhead is very minimal. Thanks again and a Good Day wished to you all.

Dan

Dan Rogotzke
Daniel_Rogotzke@oxy.com

 

[TheAceMan1]

Roger that aliendan . . .

However:

[blue] . . . Since the value used needs to be dynamic . . .[/blue]

For your reference, db properties are [blue]read/write[/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[aliendan]

Hehe...when I have time I am going to look deeper into the db properties thing so I can understand it better and make use of it in the future. Thank you so much for the info.

Dan

Dan Rogotzke
Daniel_Rogotzke@oxy.com