Pulling a value from a table

[paulmcdonnell]

Guys I know one way that i can do this through code using recordsets but is there an easier way...

I have a table which is passive and stores settings for various operations. SO it has one record only and the various fields store with different parameters.


I would like to pull the value from the table and use it in later operations

i thought i might be able to use something like :

= tables![Data_Settings]![Mailing_Address1].value

but this is obviously not possible. how else could i do it?

cheers
paul

 

[Jon K]

=DLookup("Mailing_Address1","Data_Settings")