Form code stops working

[davea300]

I have a form which I am trying to make simple changes to (i.e. label colours and text formatting). Whenever I try to make changes access hangs and won't save anything resulting in me crashing out completely. The form is quite complicated with lots of subforms.

I have tried exporting the form to a new file, making the changes there and then importing it back into the main system. The changes save sucessfully but whenever I click on a control which has code behind it the debbugger pops up with a "Compile error" message saying Method or member not found. The old version of the form still works fine and the code is exactly the same in both. I know the export has probably caused it but I don't know how to fix it.

Have I missed something obvious?

Access version 2003 running in 2000 format for this database.

 

[scalextric59]

Not too long ago, I had a similar issue. I inherited a form that needed to be updated. Everytime I tried to save my changes, I got an Access message stating that the changes could not be saved, Access froze, and had to kill the process. After doing things like recreating the form, convertint to text, etc. I found out the problem. It was the rowsource from a combo box. It was "SELECT * ..." and the combo box was only 2 columns. Fixed this, and the issue dissapeared.

 

[boblarson]

... whenever I click on a control which has code behind it the debbugger pops up with a "Compile error" message saying Method or member not found.

Also, besides what scalextric59 has suggested, you can try going into the VBA Window and going to DEBUG > COMPILE (yourProjectName) and let it take you to any errors (it will highlight an error and you can fix it and then run it again to check for more. Keep doing that until you get no more errors).