M
Ming
I have a a button on a main form which does following, save the value and
open another form, which has another subform on it. After I enter customer
ID, click the "Requester" button and then click the exit button on the main
form to exit, the Form_BeforeUpdate event is not fired. I have other buttons
on the main form, after I click those buttons and click "Exit" button, the
Form_BeforeUpdate event fires.
I have some validation code in form_beforeupdate event, How can make sure
that form_BeforeUpdate always fires when I make changes
Private Sub RequesterButton_Click()
DoCmd.DoMenuItem A_FILE, acFormBar, A_SAVERECORD
DoCmd.OpenForm "fdgRequesters", acNormal, , , , acDialog,
,Me!lngCustomerID
DoCmd.Close acForm, "fdgRequesters"
Exit Sub
open another form, which has another subform on it. After I enter customer
ID, click the "Requester" button and then click the exit button on the main
form to exit, the Form_BeforeUpdate event is not fired. I have other buttons
on the main form, after I click those buttons and click "Exit" button, the
Form_BeforeUpdate event fires.
I have some validation code in form_beforeupdate event, How can make sure
that form_BeforeUpdate always fires when I make changes
Private Sub RequesterButton_Click()
DoCmd.DoMenuItem A_FILE, acFormBar, A_SAVERECORD
DoCmd.OpenForm "fdgRequesters", acNormal, , , , acDialog,
,Me!lngCustomerID
DoCmd.Close acForm, "fdgRequesters"
Exit Sub