RunMacro cannot find submacro object.

[weasel7711]

I am running Access 2010 and I am creating a Web Database (so I can't just start typing VBA code)



I have a form that allows the user to browse through entries in a table in a more aesthetically pleasing way than a datasheet view. I have the default setting so that all the textboxes for the fields are locked. There is an "Edit" button that runs a macro which will allow these textboxes to be locked/unlocked when this button is clicked. I have a TempVar that keeps track of whether the form is currently locked or not. I have a submacro at the end of this macro called SetLocked which sets each text box. When I select the RunMacro command, the submacro does not appear in the drop down list for the RunMacro command. If I put in the macro name manually it throws an error when the macro runs:

Microsoft Access cannot find the object 'SetLocked'

and the error number 2485

[weasel7711]

Does anyone know what could be going on here?

[weasel7711]

I found a temporary fix. I moved the submacro to its own module and referenced it that way. I still have no way to reference a submacro within it's own module and I can't find any information via my Access2010 book, google, or youtube about how to reference a submacro inside its own module properly.