Could it be the way I named the modules
Could it be the way I named the modules?
I have each part of code named separately as Module1, Module2, Module3 and Module4.
I tried to rename them as:
And instead of getting the runtime error 424, I get a different error (this only happened when I changed the name of Module3 to UpdateToc): 'The expression OnPrint you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Access cant find.'
The function that I have in the OnPrint on the category header is: =UpdateToc([RecipeName];[Report])
Could this be the problem? The way I named the modules? Os should I keep it as it originally was - and try to resolve the 424 runtime error?