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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auditing a subform 6
Trapping access close button 4
subform afterupdate error 1
Cancel listbox selection 2
Proper Event - Leaving Record? 3
Which event to use 2
BeforeUpdate doesn't always fire 15
SubForms - Before Update Problem 5

Back
Top