Problem with Table column names in VBA module

[Keith]

Hello,
In My VBA Module, I connect to a table, and then use the
notation..

with tdf
MyModuleValue = !MyTableValue
end with

...to assign values used within the module.

It appears that !MyTableValue is always a constant because
it can only apply to a specific named column in the
table. How can I make it a variable, so that one time
I'm use one column, and another time I can use another
column without editing the code.

Any ideas?

Keith

 

[Chris]

with tdf
MyModuleValue = .Fields(strFieldName).Value
end with


Chris

 

[Keith]

Hi Chris
Seems that will work.
Thank you
Keith

-----Original Message-----
with tdf
MyModuleValue = .Fields(strFieldName).Value
end with


Chris


.