using a variable as a string expression

[Guest]

getting infor from a field wit
x=table1![field1] works fine but how do you write the code interms of a variable when string var1="table1![field1]"

 

[Duane Hookom]

Your question is a bit difficult to understand. A WAG is
=DLookup(strFieldName,strTableName)

--
Duane Hookom
MS Access MVP

getting infor from a field with
x=table1![field1] works fine but how do you write the code interms of a

variable when string var1="table1![field1]"?

 

[Albert D. Kallal]

You can use:

var1 = "field1"

x = table1(var1)