Access Closes itself?

[Apprentice]

I have a tabbed form and have created Child and Master Links etc. I was then
trying to put some code in an "AfterUpdate" property of a form that would
allow additional records to be added and retain the original ID Number
previously assigned to this form (that allows multiple records/Duplicates ok).

When I go to the "AfterUpdate" property of the control to select (Code
Builder) to insert the code... Access shuts down when I click on Code
Builder. I can access the VBA view by Alt > F-11, but even then when I
select the control the same thing happens.

I have compiled, compacted and repaired and even reversed all the
development previously done to start the process from scratch, I even removed
the control from the form and readded it. Access still closes when I try to
mess with this specific control.

Any thoughts.... or prayers would help.

 

[Marshall Barton]

I have a tabbed form and have created Child and Master Links etc. I was then
trying to put some code in an "AfterUpdate" property of a form that would
allow additional records to be added and retain the original ID Number
previously assigned to this form (that allows multiple records/Duplicates ok).

When I go to the "AfterUpdate" property of the control to select (Code
Builder) to insert the code... Access shuts down when I click on Code
Builder. I can access the VBA view by Alt > F-11, but even then when I
select the control the same thing happens.

I have compiled, compacted and repaired and even reversed all the
development previously done to start the process from scratch, I even removed
the control from the form and readded it. Access still closes when I try to
mess with this specific control.

Before making matters any worse, BACKUP the database.

Sacrificing a virgin chicken on your keyboard/alter might
help ;-)

It sounds more like the form's module is corrupted, so I
think you should try decompiling first. See
http://www.granite.ab.ca/access/decompile.htm

If that doesn't allow you to proceed, then create a new
blank mdb file with the references and option settings
(especially make sure NameAutoCorrect it OFF. Then, use
File Import to bring **everything** into the new db (when
selecting the forms to import, select each form
individually, DO NOT use Select All)

 

[Apprentice]

Thanks Marshall, the decompile did the trick!