So now I have completed Access 204 and I know a little bit more about macros.  I put the same code into the macro builder as a “run code” and saved it.  I then entered the name of the macro into the Before Insert line in my JobEntryF form.  I tried to enter a new job in the form and got the following error message:

A macro can call itself a maximum of 20 times.

Your macro contains a RunMacro action that calls the same macro more than 20 times.
Use a condition to stop the macro after it has been run 20 times, or call another macro with the RunMacro action.

OK  (button)


So at this point I don’t know why the macro is running more than 20 times.  Is each check of the value in my table considered a run?  Should I be entering the code as an SQL statement for the job number value in my form?  I will continue looking for the answer to this in the classes and some other “expert” I know, but any help would be nice….