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.
Cheers
Ceebaby

 

[Tom van Stiphout]

On Mon, 15 Feb 2010 13:11:29 GMT, "Ceebaby via AccessMonster.com"

Your syntax seems correct. Perhaps you have some form of corruption.
You could put a backup back, or try to Compact the database.

-Tom.
Microsoft Access MVP