BeforeUpdate property of a control on a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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

WC Lo said:
I have a combo box on a subform. The combo box has a pull down list. I
Click to expand...
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
Click to expand...
same? Appreciate for any advise.
 
Back
Top