Seeing VBA code associated with a MS Access 2010 form

[Lou_Reed]

Each form in MS Access 2010 has its own associated VBA code. So if I am looking at a form how do I see the code associated with that VBA form?



I tried alt-F11 and it seems to work, but not all of the time. Sometimes it fails.

So maybe there is way more sure fire way to see the code associated with the form.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

Alt-F11 should open the code editor. Normally there's a window to the left that lists all the forms and reports with code plus modules. If you don't see that, click on View/Project Explorer. You can double click on any item in it to see that code.

[aytee111]

Under Design on the far left is a View Code icon.

[Lou_Reed]

Is it possible to go in reverse? I have some VBA code in a project that I have been unable associate with a form. It is the first to print out when I print the project and it does have a form name associated with it. I be darned if I can find the form though..


So instead of trying every form in the db and seeing if the VBA code matches. I could start with the code and then associate the correct form from the code.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed