How to get table value in a VBA variable ?

[Nikko]

hello,

i have a table VAR with a variable POS containing a numeric value
(representing a cursor used to print forms beyond this value).

How can i get the POS variable value in a VBA variant variable.
what method do i have to use ?

thank's

 

[Allen Browne]

Use DLookup()

If you are not sure how to supply the arguments, see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

 

[Nikko]

Allen Browne a écrit :

Use DLookup()

If you are not sure how to supply the arguments, see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

thank you Allen you're the Boss !

Could you have a look at my question on m.p.access.
if you could solve that case you would be a world Boss !