I am trying to set a conditional format for a required field based on the value of another field from the same table. I am trying to do this from the form that inputs the data in to the table.
In other words, if the value of field A = 2, I want the value of the required field to be "yes" or "no" (this is a user input). If the value of field A is not 2, then the value of the required field is null.
I've been experimenting with Iif statements for several hours and I'm at a loss. I am familiar with the basics of SQL but this seems to be beyond my expertise.
Any help would be greatly appreciated!!