I am having a problem with a #Name? error on a Form that shows my projects in a list view.
I have a text box field with the formula: =IIf(IsNull([ID]),"(New)","Open"). If the result is "Open" a user can click on the "Open" link and it runs a macro that opens a detail form.
It was working...