Access Crashes when VBA code is modified

M

Malcolm WTII

Hi,
I have a form in a DB that has VBA code. I copied it to a new form. I
renamed the original to something_backup, and renamed the copy to the same
name as the original. I then modified the form to use a different table as
its source, along with some field changes, etc.

The form opens and works as it should. But now, when I go into the VBA
editor, the only thing I can modify with no problems is my module1, which
has startup stuff in it. If I modify anything in the form's code, even just
inserting a space, comment, backspace, anything, Access immediately crashes.
It was fine before. I have run Compact & Repair, no success. This is
Access 2002.

Ideas?
M
 
L

Larry Daugherty

Allen Browne posted something that might be useful to you in the last
week or two. Use your newsgroup reader's "Find" to find a reply from
Allen Browne and in the text portion, enter "/decompile" without the
quotes.
 
M

Malcolm WTII

Thanks Larry, Allen's article was quite helpful and proved to be the
solution. (Thanks Allen!)

Regards,
M
 
L

Larry Daugherty

You're welcome.

--
-Larry-
--

Malcolm WTII said:
Thanks Larry, Allen's article was quite helpful and proved to be the
solution. (Thanks Allen!)

Regards,
M
Click to expand...
 
Top