Get values from a field in a specific record number

[ericsson]

Hi,

How do I get the value from a field in a specific recordnumber, in a Sub.

//Lasse

 

[Allen Browne]

Use DLookup().
Pass the primary key value to find in the 3rd argument.

Details in:
Getting a value from a table: DLookup()
at:
http://members.iinet.net.au/~allenbrowne/casu-07.html