Is it possible to define global variable in select

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tina - 11 May 2004 00:23 GMT

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

Reply to this Message

Tony C - 11 May 2004 10:35 GMT

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.

>-----Original Message-----
>I would like to put the data retrieved in my
[quoted text clipped - 9 lines]
>Tina
>.

Reply to this Message

TC - 12 May 2004 04:55 GMT

(snip)

> Public TempStr,SearchString As String

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

HTH,
TC

Reply to this Message