Mark A Matte
markamatte at hotmail.com
Mon Sep 18 11:22:47 CDT 2006
Thanks for the feedback...I found my brain cramp...you have to declare a global variable in a module...not a class module?.?.?...I think...lol But it works now. Thanks, Mark A. Matte >From: "Robin " <Robin at rolledgold.net> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] Global Variable??? >Date: Mon, 18 Sep 2006 16:43:48 +0100 > >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 >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com