[AccessD] Global Variable???

Hi Mark,
If I understand you correctly you need to assign the dlookup value to a
variable....

eg strlocation = dlookup("location","tblLocations","ID=2")

Then use strlocation in your module....
Rgds
Robin


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: 18 September 2006 16:44
To: accessd at databaseadvisors.com
Subject: [AccessD] Global Variable???


Hello All,

I have an A2k db...and apparently am having a brain cramp.  On a 
form...click a button...uses Dlookup to find which path to a folder we
are 
going to use...  Location = dlookup("location","tblLocations","ID=2")

The Dlookup works fine...but I need to pass this value to a function in
a 
module...whenever I put "location" in the Module...it says variable not 
defined.  I've tried everything I can think of.


Please help?

Thanks,

Mark A. Matte


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com