Can't run macro from FE

[sumdumgai]

I have a split database with an Autoexec macro in both the FE and BE. The VBA function that is executed exists in both FE and BE. The macro runs fine in the BE but gives error in FE:


"the expression you entered has a function name that Microsoft Access can't find."


Are FE macros allowed?

 

[sumdumgai]

Never mind. Found my problem. VBA code was not in a module but in a Form class module.

 

[The_Doc_Man]

Yep, that'll do it. (A) Class modules are inherently private and (B) if the particular form wasn't active at the time, the function isn't in memory where it can can be called. So either of those reasons will stop you.