I set up a macro that runs a code that checks record counts for a few of my tables. It does this for 3 tables. The first two work fine, but I just added a new one that is giving me problems. When I first set up the macro, it works fine; however, when I close the database and go back into it, I get an error that says Access can't find the function I am trying to run. When I check the Run Code part of my macro, the name of the function appears to be perfectly fine. For some reason, when I re-type the function name in the run code macro it works, even though the function name is perfectly fine and I just re-typed the same thing.
Is this some sort of bug and is there anything I can do to fix it?
Is this some sort of bug and is there anything I can do to fix it?
