BeforeUpdate event on a subform

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

Guest

How can I respond to the BeforeUpdate event on a subform? It is not an
available event when I choose the subform object in VBA.

Thanks in advance,
Emily
 
The subform object is the control on the main form that holds the subform
and, you're correct, it doesn't have a BeforeUpdate event. To use the
BeforeUpdate event in the subform, you need to use the form event in the
subform itself. Open the subform itself in design mode and place the code in
its BeforeUpdate event.
 
Back
Top