Text value available for other forms

I thought that you could take a value created in a text box of
one form & make it available for use by other forms in the same
database as until you closed that database.
If this is possible could someone post the code needed to do it.
I believe you have to create a Public?? variable or something
like that but am not having any luck finding documentation on
this subject.
Thanks for any tips on how to do this or where to look for more
info.
dc

re: Text value available for other forms

"doncee" <nodbcspam9814wanted@charter.net> wrote in message
news:Xns9785A2B7380E3medbcSWBEll@216.196.97.131...[color=blue]
>I thought that you could take a value created in a text box of
> one form & make it available for use by other forms in the same
> database as until you closed that database.
> If this is possible could someone post the code needed to do it.
> I believe you have to create a Public?? variable or something
> like that but am not having any luck finding documentation on
> this subject.
> Thanks for any tips on how to do this or where to look for more
> info.
> dc[/color]


The form has to be open - although it can be hidden.

strMessage=Nz(Forms!MyForm.txtMyTextbox.Value,"")
Msgbox strMessage

re: Text value available for other forms

"Anthony England" <aengland@oops.co.uk> wrote in
news:dv4qsb$pr6$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com:
[color=blue][color=green]
>>I thought that you could take a value created in a text box
>>of
>> one form & make it available for use by other forms in the
>> same database as until you closed that database.
>> If this is possible could someone post the code needed to
>> do it. I believe you have to create a Public?? variable or
>> something like that but am not having any luck finding
>> documentation on this subject.
>> Thanks for any tips on how to do this or where to look for
>> more info.
>> dc[/color]
>
>
> The form has to be open - although it can be hidden.
>
> strMessage=Nz(Forms!MyForm.txtMyTextbox.Value,"")
> Msgbox strMessage
>
>[/color]

Thanks for the reply. I'll give it a try.
dc