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.
--
Your guidance is greatly appreciated!

Apprentice wrote:

>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)

--
Marsh
MVP [MS Access]

Thanks Marshall, the decompile did the trick!
--
Your guidance is greatly appreciated!


"Marshall Barton" wrote:

> Apprentice wrote:
>
> >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)
>
> --
> Marsh
> MVP [MS Access]
>