Hi all,
I am writing a web database (so need to use macros rather than VBA). I am trying to pass a field name as a parameter (prmRole) and then use SetField to update the value of the field in a data macro in Access 2010. Unfortunately, Access kicks up the error:
"The Identifier '[prmRole]' could not be found"
I have tried =[prmRole], ="[prmRole]" and "[prmRole]" but not seem to help. Is this possible?
Hopefully the attachment will upload and give more info.
Ian