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

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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top