Referencing a control on subform 1 from subform 3 causes access to crash

[Ceebaby via AccessMonster.com]

Hi Folks

Using Access 2003 SP3, I have a main form with 3 linked subforms to a
propertyID and fundID on the main form.

On the AfterUpdate Event of a field on subform 3 I would like the value to
be transferred to a control field on subform 1. This is the syntax I have on
subform 3

Forms!FrmFOA!FrmGrantSubFrm.Form![CertDate] = Me!CertificateDate

frmgrantSubFrm is subform 1

Every time I enter data in the field to trigger the AfterUpdate event Access
crashes.

I have gone through the form to see if there is any other event happening at
the same time but this is the only piece of code.

This was working well before but this behaviour has started recently.
Any help will be most appreciated.

Sorry for double posting i mistakenly put this in the queries forum.
Cheers
Ceebaby

 

[ruralguy via AccessMonster.com]

Have you already applied the 2003 HotFix?
http://support.microsoft.com/kb/945674

I would also try importing your db into a new db and see if the problem
follows.

Hi Folks

Using Access 2003 SP3, I have a main form with 3 linked subforms to a
propertyID and fundID on the main form.

On the AfterUpdate Event of a field on subform 3 I would like the value to
be transferred to a control field on subform 1. This is the syntax I have on
subform 3

Forms!FrmFOA!FrmGrantSubFrm.Form![CertDate] = Me!CertificateDate

frmgrantSubFrm is subform 1

Every time I enter data in the field to trigger the AfterUpdate event Access
crashes.

I have gone through the form to see if there is any other event happening at
the same time but this is the only piece of code.

This was working well before but this behaviour has started recently.
Any help will be most appreciated.

Sorry for double posting i mistakenly put this in the queries forum.
Cheers
Ceebaby

 

[Ceebaby via AccessMonster.com]

Thanks for the response RuralGuy. Will try this - not sure if I installed
this previously. Currently seeing if subform 3 being a continous form with
oncurrent events is the cause.
Cheers
Ceebaby
London

Have you already applied the 2003 HotFix?
http://support.microsoft.com/kb/945674

I would also try importing your db into a new db and see if the problem
follows.

Hi Folks

[quoted text clipped - 21 lines]

Cheers
Ceebaby