I have an Access 2007 form named frmCreateBatch with a textbox named Client. I have a string variable Where.
Here is the line of code causing the error:
Where = IIf([Forms]![frmCreateBatch]![Client] Is Not Null, [Forms]![frmCreateBatch]![Client], "Now is the time")
If I don't enter anytihing in the textbox, I simple want to set the var Where to a string value, in this sample "Now is time"
What am I missing?