Puzzling #Name? error

[sprovoyeur]

I download the MS Task List template for Access 2007. I added a couple of fields to the Tasks table and now when I open the form I get a #Name? error in the "Open" field. The control source for the field reads "=IIf(IsNull([ID]),"(New)","Open")". I have not modifed it in any way. Really haven't done anything except added a couple of new fields to the table? And now when I double click on this function and then try to navigate away from this field I get "There was an error compiling this function" error. But I haven't changed anything? I don't get any of these errors in the unmodified version but I need to tweak it to fit our needs. I Googled the problem and looked at all the suggestions, ie, naming problems, deleted fields, etc, but none apply here? If anyone has any suggestions I would very much appreciate the feedback.

[RuralGuy]

Fields do not have a ControlSource but a Control on a Form *does*, which makes what you said a bit difficult to read and understand. Do you have a CONTROL on your Form that displays the [ID] FIELD from the RecordSource of the FORM?

[sprovoyeur]

My appologies for the confusion. Yes, the "ID" field is on the form. Then under that is a text box with the control source set to the IIF statement. This is how the template downloads from the MS website, only that one works. The form is a split form with bottom half displayed as a datasheet. This text box field is the first one on the left and will read "Open" for all populated records is populated and "New" if not(the last record). When open is clicked it brings up the detail for that record. The frustrating thing is that I know it is something I did to the database because the original template works fine. But I can catagrically say that I have not modified that text box or the ID field in any way. I haven't done that much to it but apparantly it was enough. Something I did has to be affecting it. I may have to just start with the original agian and try to backtrack but I'm holding out before I do that. Thanks again for answering.

[RuralGuy]

You said you downloaded a 2007 Template but you use ac2003. Is this correct?

[sprovoyeur]

I am using Access 2007.

[sprovoyeur]

Some additional info. When I open Access, then open the form, the field says "#Name?". If I simply remove or add any field to the form and then open it, it works fine and no longer says "#Name?". If I save and then reopen Access we are back to square one and it doesn't work any more.

[RuralGuy]

You are getting strange results. I would start over. Do *NOT* make any changes to code while the debugger is running. It has been known to cause problems.

[RuralGuy]

Did you want to change your profile so it shows you as using ac2007?

[sprovoyeur]

Thanks for getting back to me RuralGuy and sorry about the misinfrmation in the profile. I just changed it to relect what I am using. And I think you're right, I'm just going to start over and keep an eye on what I change. Thanks for your assistance.

[RuralGuy]

It could easily be some sort of corruption and next to impossible to pin down.