Afterupdate Event not reading entire Macro Group

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

Guest

Hello -
I have created a macro group that is to open a second form based on a value
entered in one field of the first form. Access is only reading the first line
of the macro group, not the subsequent ones. Macro details are below. I have
entered the name of the macro on the Event Tab of the main form (Appointment
Processing) in the AfterUpdate field.

Any assistance is greatly appreciated.
Thanks!
Amy

Macrogroup: FormMacro
Actions Name: APNEWHIRE
Condition: [Forms]![AppointProcessing]![Transtype] = "NHAP"
Action: OpenForm
View: Form
Value: APNEWHIRE
Actions Name: CSNEWHIRE
Condition: [Forms]![AppointProcessing]![Transtype] = "NHCS"
Action: OpenForm
View: Form
Value: CSPNEWHIRE
Actions Name: FACNEWHIRE
Condition: [Forms]![AppointProcessing]![Transtype] = "NHFC"
Action: OpenForm
View: Form
Value: FCNEWHIRE
Actions Name: SEPARATION
Condition: [Forms]![AppointProcessing]![Transtype] = "TERM"
Action: OpenForm
View: Form
Value: SEPARATION
Actions Name: FOAPAL
Condition: [Forms]![AppointProcessing]![Transtype] = "FOAP"
Action: OpenForm
View: Form
Value: FOAPAL
Actions Name: OTHER
Condition: [Forms]![AppointProcessing]![Transtype] = "AJOB"
Action: OpenForm
View: Form
Value: OTHER
Actions Name: OTHER
Condition: [Forms]![AppointProcessing]![Transtype] = "LUMP"
Action: OpenForm
View: Form
Value: LUMP
 
Amy,

I suggest you remove all entries in the Macro Name column (APNEWHIRE,
CSNEWHIRE, etc), and try again.
 
Works great!
Thanks


Steve Schapel said:
Amy,

I suggest you remove all entries in the Macro Name column (APNEWHIRE,
CSNEWHIRE, etc), and try again.

--
Steve Schapel, Microsoft Access MVP

Hello -
I have created a macro group that is to open a second form based on a value
entered in one field of the first form. Access is only reading the first line
of the macro group, not the subsequent ones. Macro details are below. I have
entered the name of the macro on the Event Tab of the main form (Appointment
Processing) in the AfterUpdate field.

Any assistance is greatly appreciated.
Thanks!
Amy

Macrogroup: FormMacro
Actions Name: APNEWHIRE
Condition: [Forms]![AppointProcessing]![Transtype] = "NHAP"
Action: OpenForm
View: Form
Value: APNEWHIRE
Actions Name: CSNEWHIRE
Condition: [Forms]![AppointProcessing]![Transtype] = "NHCS"
Action: OpenForm
View: Form
Value: CSPNEWHIRE
Actions Name: FACNEWHIRE
Condition: [Forms]![AppointProcessing]![Transtype] = "NHFC"
Action: OpenForm
View: Form
Value: FCNEWHIRE
Actions Name: SEPARATION
Condition: [Forms]![AppointProcessing]![Transtype] = "TERM"
Action: OpenForm
View: Form
Value: SEPARATION
Actions Name: FOAPAL
Condition: [Forms]![AppointProcessing]![Transtype] = "FOAP"
Action: OpenForm
View: Form
Value: FOAPAL
Actions Name: OTHER
Condition: [Forms]![AppointProcessing]![Transtype] = "AJOB"
Action: OpenForm
View: Form
Value: OTHER
Actions Name: OTHER
Condition: [Forms]![AppointProcessing]![Transtype] = "LUMP"
Action: OpenForm
View: Form
Value: LUMP
Click to expand...
Click to expand...
 
Back
Top