Menu callback function in Form's code module

[Edward]

Access 2k FE/BE

My application allows users to enter employee hours against rotas
(i.e. who is rostered on, and when).

They further want a function to output a report showing the number of
hours that each employee is rostered, and to be able to do this for
any week. To this end there is a control on the "Rota" form which
shows the "Week Commencing", with "Next >" and "< Previous" buttons.

They want to kick this report off using a menu item. So I created a
custom menu with an option "Calculate Hours", and put the callback
function in the code behind the "Rota" form (the "Rota" form must be
loaded to get the "Week Commencing" value.

However, if I put the code there, Access puts up an error:

"can't run the macro or callback function"

If I move the function to a module, it works.

This is not a big issue, but am I right therefore to conclude that
menu callback functions can ONLY exist in modules?

TIA

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk