Passing a name of a field in a parameter - is it possible?

[zinrey]

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

[June7]

I think not.

Why do you need to? Is the data not going to the same field for each new record?

[zinrey]

I think not.

Why do you need to? Is the data not going to the same field for each new record?

Good question as to why. I have a number of fields with names of different people on a project. By having a number of roles each defined as a new field I can pull out the roles in queries, forms, reports etc. easily.


I have solved this with an If statement in the end. It is two step and I need one for each role so it took quite a lot more lines of code but it is working.

i.e.

If [prmRole]="Producer" Then
SetField (Producer, [prmString])