Referencing a control on subform 1 from subform 3 causes access to crash
in [Form]
|
Prev: Closing Balance figure to be carried as Opening Balance in a new record
Next: Opening Forms based on Combo Box Selection (Accesss 2007)
From: Ceebaby via AccessMonster.com on 15 Feb 2010 08:25 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 Trying to be great at Access Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1
From: ruralguy via AccessMonster.com on 15 Feb 2010 10:44 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. Ceebaby wrote: >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 (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1
From: Ceebaby via AccessMonster.com on 15 Feb 2010 10:48
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 ruralguy wrote: >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 > -- Ceebaby Trying to be great at Access Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1 |