Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Debugging an Object Event

Status
Not open for further replies.

bostonfrog

Programmer
Jul 14, 2003
79
MX
I have a book here on using VBA in Access and using the immediate window to run a sub or function. But let's say you were looking at the code module of a Form's Close or Open Event. How could you debug that in the immediate windows. Normally I'd type the function or sub's name preceded by a ? followed by [Enter] but what do I type in for events, such as Sub Form_Open() or Sub Form_Close() ?
-- Michel
 
boston,

You could put a break point in the event, or...

...you could make the event Public, then in debug window (with form open):

Forms!SomeForm.SomeButton_Click

...this will fire that click event.

Events with included args (such as before_update) will give you a problem.
--jsteph
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top