Is it possible to define global variable in select

[Tina]

I would like to put the data retrieved in my
select statement into global variable to be used
in other forms. Is it possible?

select order no as <globalvarialbename> from table1

then I would like to use <globalvariablename> in
other queries, etc.

Thank you,
Tina

 

[Tony C]

This response is if you are referring to Vb Variables: -

I have been using public variables for some time now, in
the following manner: -

1. Create a Module entitled "PublicVariables"
2. Declare all variables in here that are shared between
more than one Form/Procedure: -

Public TempStr,SearchString As String

etc....

HTH


Tony C.

 

[TC]

(snip)

Public TempStr,SearchString As String

You realize that defines TempStr as a Variant - not a String?

HTH,
TC