Extacting a Value from a table and setting a variable equal to it

[Jeff]

In VB code, in Access a module, how could I extact a
single value from inside a table and set a variable equal
to that value. I need the code to do this. Please
help. Jeff in LA.

 

[Allen Browne]

Use DLookup().

This article explains how to supply the 3 arguments:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html