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 fine for a while, then all of a sudden, I got the #Name? in that field when I opened the form.
One time, I used the "Refresh" button and that cleared the error and the formula worked again. Now however when use the Refresh menu command I get prompted for: "Enter Parameter Value: Application.CurrentObjectName and a field to make an entry and the OK/Cancel buttons.
Today, I changed the name of the text box and that worked restored the functionality of the formula temporarily, everything was fine until I closed the database. When I reopened the database, I am back to the #Name? error in this field.
Runnning a C/R has no effect.
I am not a programmer, I just built an application around the Tasks sample database. Thanks for any help, I am stuck.
Access 2010
Windows XP Pro
IE ver 8
<!--IBF.ATTACHMENT_2106226-->
<!-- THE POST -->
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 fine for a while, then all of a sudden, I got the #Name? in that field when I opened the form.
One time, I used the "Refresh" button and that cleared the error and the formula worked again. Now however when use the Refresh menu command I get prompted for: "Enter Parameter Value: Application.CurrentObjectName and a field to make an entry and the OK/Cancel buttons.
Today, I changed the name of the text box and that worked restored the functionality of the formula temporarily, everything was fine until I closed the database. When I reopened the database, I am back to the #Name? error in this field.
Runnning a C/R has no effect.
I am not a programmer, I just built an application around the Tasks sample database. Thanks for any help, I am stuck.
Access 2010
Windows XP Pro
IE ver 8
<!--IBF.ATTACHMENT_2106226-->
<!-- THE POST -->
