I think its highly unlikely it will work using a macro when VBA fails.
I suggest the following strategy:
1. Make a copy of your form. Remove the MatrixUpdated control & comment out both code lines
Does the code compile now ... or fail at another line?
If not OK, go to step 2
If it is OK, add a new control with the same name, restore the 2 code lines & test again.
2. Decompile your database - this will remove any compile code including any which may be corrupted
This link explains how & why this is useful
http://www.fmsinc.com/MicrosoftAcces.../Decompile.asp
Now RECOMPILE then COMPACT & try the form code again
If it fails, go to step 3
3. Look in the VBE and see whether you have any leftover objects starting ~TMPCLP
If so these are objects left over after a database crash
If you have any, read this article to see how to deal with them: https://www.access-programmers.co.uk...d.php?t=293579
Then test the form again
4. If you still have problems create a new database & import all objects into that
Good luck
not sure what this means. The compile option is greyed out?I can no longer compile the database.
What do you mean by 'too much work'. You already have VBA procedure. Suggested edit is simple.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.