I am having a very odd thing happen in one of my forms. I have added 8 if statements that simply display a line of text if a statement is or is not null. The if statement looks like this:
IIf([AttributesPrivateNote] Is Not Null,"Private Notes Available","")
Each field is looking at differnt fields.
When I first open access it comes up as an error message "#Name?" on all of the fields. If I go into design view in the form and add or remove anything, Even add a text box with a peroid, and then go back into the form all the fields work and will continue to work until I close access. Once I reopen access those fields don't work again.
Any ideas?
IIf([AttributesPrivateNote] Is Not Null,"Private Notes Available","")
Each field is looking at differnt fields.
When I first open access it comes up as an error message "#Name?" on all of the fields. If I go into design view in the form and add or remove anything, Even add a text box with a peroid, and then go back into the form all the fields work and will continue to work until I close access. Once I reopen access those fields don't work again.
Any ideas?
