Putting a variable in a Me statement

[Peter Bellamy]

Can someone please guide on this?

I have the following line
StrProd = Me.certgas_product

I want to rewrite this using a String variable, StrTbl inplace of the 'certgas_'

StrProd = "Me." & StrTbl & "product" just assigns StrProd to that string, not the underlying value.

Thanks

 

[pbaldy]

Try

Me(StrTbl & "product")

 

[Peter Bellamy]

Thanks Paul

 

[gemma-the-husky]

note that the me bit is superfluous for most of this stuff