BeforeUpdate property of a control on a subform

[Guest]

I have a combo box on a subform. The combo box has a pull down list. I use the AfterUpdate event to update other controls from the pull down list. It works perfectly.

Usually we use BeforeUpdate to validate data. In this case, can I do the same? Appreciate for any advise.

 

[MacDermott]

That would depend on what you're validating, and which BeforeUpdate event
you're using.
If you're using the form's BeforeUpdate, I don't see any problem, as this
won't fire until you leave the record.
If you're using the combobox's BeforeUpdate, you're still fine as long as
it's only the data in the combobox itself that you're validating.
However, if you want to validate some of the data in the controls which are
updated in the AfterUpdate event, you should be aware that the update will
not yet have happened at the time you're performing your validation.

HTH
- Turtle

I have a combo box on a subform. The combo box has a pull down list. I

use the AfterUpdate event to update other controls from the pull down list.
It works perfectly.

Usually we use BeforeUpdate to validate data. In this case, can I do the

same? Appreciate for any advise.