Do.Cmd RunMacro not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro named Step_6. Based on what the value is in Forms!Data!Step_5,
it assigns a number to Forms!Data!Step_6. There are approx 80 lines (this is
part of a body fat calculation worksheet) and the macro works great by itself.

I wanted to automate things a little more and tried to do:

DoCmd.RunMacro (Step_6)

Did Complie-->Debug and it finds no error, but when I update the field
Step_5 I get a "Run time error 2502. The action or method requires a Macro
name argument". The Repeat and Expression can be left blank, so I don't
understand!!!
Somebody please help!
 
When I change () to "", it locks the whole thing up and I have to close
Access. Running Access 2000. Any ideas?
Thanks, George!
 
Also, here is the whole sub. Am I trying to do to much at once? When it locks
up, I'm able to put one digit in and then it freezes.

Private Sub ABD_1_Change()
ABD_AVG = (ABD_1 + ABD_2 + ABD_3) / 3
STEP_5 = ABD_AVG - MALE_NECK_AVG
DoCmd.RunMacro "MALE_STEP_6"
MALE_STEP_8 = STEP_6 - MALE_STEP_7
If MALE_STEP_8 > MALE_AUTHORIZED Then
Meets_AR_600_9 = "NO"
Else
Meets_AR_600_9 = "YES"
End If
End Sub
 
Back
Top