Very new to VBA. I know this question probably has a very simple answer but I'm not able to find anything about it on the interwebs.
When using the IIf function, I am wanting to use the value of a variable ("subj") to determine which field in the form I am wanting to evaluate.
So, if my variable name is "subj", how would I do this? Since, to check the field "S1" of the form, my code would look like this:
...I would assume that my variable would need to be wrapped in some way to identify it as such rather than as the name of the form. How would I do this?
When using the IIf function, I am wanting to use the value of a variable ("subj") to determine which field in the form I am wanting to evaluate.
So, if my variable name is "subj", how would I do this? Since, to check the field "S1" of the form, my code would look like this:
Code:
(IIf([S1], 1, 0))
...I would assume that my variable would need to be wrapped in some way to identify it as such rather than as the name of the form. How would I do this?