Hi all.
In part of my workflow, I am given an xls document which may or may not contain a field called "ListMonth." What I want to do on my form is create a checkbox that will allow the user to check whether the field is present. If so, I wish to use the field ListMonth. If not, I want to prompt the user to enter a month.
What I have currently:
ReviewMonth: IIf(Forms!myForm!chkListMonth= -1, myTable.ListMonth, [Enter Month of Campaign])
This, however, always prompts for the month of the campaign. I've spelled everything correctly. Thoughts?
Thank you