Problem with Table column names in VBA module

  • Thread starter Thread starter Keith
  • Start date Start date
K

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
 
Back
Top