If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Referencing a control on subform 1 from subform 3 causes access to crash
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/For...forms/201002/1 |
#2
|
|||
|
|||
Referencing a control on subform 1 from subform 3 causes access to crash
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/For...forms/201002/1 |
#3
|
|||
|
|||
Referencing a control on subform 1 from subform 3 causes access to crash
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/For...forms/201002/1 |
Thread Tools | |
Display Modes | |
|
|