Execution of DoCmd failure

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have a form built in Access 2000, which when the user
has finished filling out the form, they click on a check
box. The programming I have has a
DoCmd.RunMacro "updates". When a user first logs into the
database this causes an error and forces the user to
either end or debug. But if the user attempts to do the
action again there is no problems and the function works
perfectly fine as long as the user does not logout/close
the database. The Macro executes fine if run alone, as
do the queries associated with the macro. It is ALWAYS
JUST the first time a user opens the form and places the
check mark in the specified box that this error occurs.
After that there are no problems and no errors. This has
me totally stumped, All permissions for the user are
there as well.
 
Try converting the macro to code (use the SaveAs option) and then execute
the subroutine that is created. This will add error trapping to the macro
code and will help you pinpoint what is happening.
 
Back
Top