MS-ACCESS : How to get a final result of [lookup table] which field is <string_variable> ?

W

warn3t

Joined
Oct 7, 2012
Messages
1
Reaction score
0
A. My Table
[TABLE_1]
--------------------------
N | STRING_VARIABLE
--------------------------
1 | cAuthor

B. My Variable
Public cAuthor as string
cAuthor = "Mr. Warnet"

C. My DLookup
MyLookup = DLookup ("STRING_VARIABLE", "TABLE_1", "N = 1")

D. My DLookup Result
MyLookup = "cAuthor"

E. My Question
How to get "Mr. Warnet" as the lookup result directly?
(instead of "cAuthor")

F. Thanks
 
Last edited:
Back
Top