[AccessD] DAO Fiekd Name String/Variable

Hello to the list,

I woild like to:
1. get a value from one table as a string
2. lookup the value of a field in a second table 
where the field name = the value of field in table 1
Using !s if possible.

TIA

best 


Bob