SQL Value

[Dodge]

Hi,

Here's another brainbuster form an anoying newbie

How do I run a query and have it store the value in a variable?

For instance:

LocationStr = "SELECT [Location] FROM [dbo.Users] WHERE [Badge#] = '" & UserHolder & "'"

Well I want LocationStr to remember the value that the query returns not the query. I've tried to use the DoCmd.RunSQL, but no go.

Any suggestions?

Thanks
Dodge

 

[JoeMiller]

Use a DLookup rather than SQL to store the value like this:

LocationStr = DLookup("[Location]","dbo.Users","[Badge#]='" & UserHolder &"'&quot

HTH Joe Miller
joe.miller@flotech.net

 

[Dodge]

Thanks, Worked like a champ...