Hi,
You didn't mention your version and build number of Office. So, I can only guess that you are most probably one of the many victims of a current Office/VBA bug. You can find details and the information about the planned fix (coming today) in our documenting AFo article.
Servus
Karl
Access Forever News DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg