Forms going wrong and GoSub Error! Why

[bofonomo]

Hi,

I have spent some time using the contacts list template in Access 2007 and altering it to suit my needs for a database. I have spend some time on it, and I got it to where i needed it to be, and did lots of testing, and made sure everything worked.

I then closed it, and before sending it off to a colleague I opened it up to make sure that the correct form would appear on opening the access data base and I get a "#name?" in the table where I would usually have "Open" or "New" (using the epression =iif(isnull([ID],"New","Open"))

Everything was working fine before closing it. If I click on the #name? I “Return without Gosub” error for condition: ="[ID]=" & NZ([ID],0).

What has gone wrong? It seems like it isn't recognising the [ID] field anymore.

I've seen explinations of how to resolve it, it doesn't seem easy to solve the issue. Is there an easy resolution? And if this has happened once, what will stop it from happening again!?

I'm not happy!

 

[jackd]

Have you tried a compact and repair?
Have you tried creating a new blank database, and then selectively copying each object from your current database to the new one?
Do you make regular backups?

 

[bofonomo]

Sorry I should have posted, I solved the problem by simply going to the run command and decompiling typing "location of msassess" /decompile "location of data base" i.e:

"C:\Program Files\Microsoft Office 2007\Office12\MSACCESS.EXE"" /decompile ""H:\Apps\MyApp.ACCDB"

Just a note I'd also turned off autocorrect before the decompiling by unchecking the box: (don't know if that makes any difference too

Office Button | Access Options | Current | Name AutoCorrect

Still don't understand why it happened, and whether it is now safe from happening again?