How to view only the module containing the Event Procedure

[RunTime91]

Greetings...

I am working in an Access database and when I click on the ellipses to view an event for a Command Button on a form the VBE opens up the module I need along with 61 other modules.



Is there any way to view only the module I need to see and prevent this 'mess' Access seems to enjoy creating each time I want to view a simple piece of code.


Thanks

[ranman256]

at the bottom, left corner of the 'code' window are 2 buttons next to the horizontal slide.
left btn shows 1 sub
right btn shows ALL subs.

[RunTime91]

at the bottom, left corner of the 'code' window are 2 buttons next to the horizontal slide.
left btn shows 1 sub
right btn shows ALL subs.

Hey Ranman Thanks for chiming in ~

Yes, those buttons work perfectly for subs in an individual window, but what I'm getting when I want to see the event procedure for a button on a single form is 62 separate modules opening (the one I need plus 61 more) for every form in the entire program.

What I would like is to just see the module for the form the button is attached to. and not the other 61 modules.

I hope I'm explaining this correctly...

Thanks Ranman

[ranman256]

I have that same problem. Something in Access keeps the other windows open.
i've closed them, saved, compacted,
but something remains behind and access opens them all!! $#%!

[June7]

I also found that annoying so I just maximum the VBA module window and then I don't see the others and I can forget they are there.