Is it possible to define global variable in select

  • Thread starter Thread starter Tina
  • Start date Start date
T

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
 
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.
 
Back
Top