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
|
|||
|
|||
Event won't fire
I have a very simple form. It's a header/detail structure with PO Header and
PO Lines. PO Lines is presented on a subform in continuous forms. Whenever I change a line, I want to add up the dollar amount and post it to the header. I know, redundant, but it'll be awhile before I can get in and fix that. My problem is that I can't get events to fire on the form. I added an AfterUpdate event to do the addition, and set an F9 break on it. It never fires. The addition is not posted to the main form. I can't seem to get this fixed. The only thing that's unusual about this form is that the form and subform began life with different names (the wizard named them, then later I renamed them). It seems the event handlers I've added since the rename are the ones not firing... Any ideas? -- Jim |
#2
|
|||
|
|||
Event won't fire
On Fri, 6 Nov 2009 13:41:01 -0800, JimS
wrote: I have a very simple form. It's a header/detail structure with PO Header and PO Lines. PO Lines is presented on a subform in continuous forms. Whenever I change a line, I want to add up the dollar amount and post it to the header. I know, redundant, but it'll be awhile before I can get in and fix that. My problem is that I can't get events to fire on the form. I added an AfterUpdate event to do the addition, and set an F9 break on it. It never fires. The addition is not posted to the main form. I can't seem to get this fixed. The only thing that's unusual about this form is that the form and subform began life with different names (the wizard named them, then later I renamed them). It seems the event handlers I've added since the rename are the ones not firing... Any ideas? There is evidently an error in your code... but we can't see your code. Please post it so we can help. Indicate the names of the forms and the (more relevant) name of the Subform Control. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Event won't fire
"My problem is that I can't get events to fire on the form."
Does this mean that no code works? If not, are you running version 2007? Code does not run in 2007 unless your database resides in a folder that has been declared a “trusted” location. To trust your folder, click: Office Button (top left) Access Options (bottom of dialog) Trust Center (left) Trust Center Settings (button) Trusted Locations (left) Add new location (button) -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
#4
|
|||
|
|||
Event won't fire
JimS -
It sounds like you put an AfterUpdate event on the form - you want it on the subform. Remember you need to leave the detail record (e.g. click somewhere else or tab out of the record) before it is updated. -- Daryl S "JimS" wrote: I have a very simple form. It's a header/detail structure with PO Header and PO Lines. PO Lines is presented on a subform in continuous forms. Whenever I change a line, I want to add up the dollar amount and post it to the header. I know, redundant, but it'll be awhile before I can get in and fix that. My problem is that I can't get events to fire on the form. I added an AfterUpdate event to do the addition, and set an F9 break on it. It never fires. The addition is not posted to the main form. I can't seem to get this fixed. The only thing that's unusual about this form is that the form and subform began life with different names (the wizard named them, then later I renamed them). It seems the event handlers I've added since the rename are the ones not firing... Any ideas? -- Jim |
Thread Tools | |
Display Modes | |
|
|