Changing an event's update sequence

[Lou_Reed]

in the attached file that contains the current db, I changed the combo box in tblAttendance.

The VBA code procedure should come after_update not before _update as it does now. I thought it would be as easy as open the after_update tab and move copied code from before_update tab to after_update and perform some editing making it suitable for an after_update event. I was wrong. It seems there is more to do than that.

I must make some additional changes. That is what this post is about. What must be considered when changing this from before to after update?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

Okay, this works now. I got this one.

I did have a question in that should all combo boxes when connected with VBA code, do it as an after_update event?

Any help appreciated. thanks in advance.

Respectfully,

Lou Reed

[jwhite]

If the acceptance of the selected value is dependent on other conditions, use the BeforeUpdate event; if not, use the AfterUpdate event. BeforeUpdate is used primarily to validate data input/selection, and AfterUpdate is used primarily to execute code based on the selection.