How do I change module name

[Bill]

This has got to be a dumb question but how do you name a module?

Access VBA automatically assigns names like "Module1", "Module2", etc.
and I can't find how you "save as" or "rename" or do whatever to
change the module name to something more useful.

 

[Roxie Aho]

-----Original Message-----
This has got to be a dumb question but how do you name a module?

Access VBA automatically assigns names

like "Module1", "Module2", etc.

and I can't find how you "save as" or "rename" or do whatever to
change the module name to something more useful.

In the Visual Basic for Applications editor, make sure the
Properties window is visible (View, Properties Window).
Highlight the Name property and type the name you want.
Roxie Aho
roxiea at usinternet.com

 

[fredg]

This has got to be a dumb question but how do you name a module?

Access VBA automatically assigns names like "Module1", "Module2", etc.
and I can't find how you "save as" or "rename" or do whatever to
change the module name to something more useful.

Select the Module name on the main database folder.
Right-click then select Rename.