Afterupdate Event not reading entire Macro Group

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
 
S

Steve Schapel

Amy,

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

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro calling a Tab 1
Macro that works in Access 2003 does not work in Access 2007 3
Open subform to specific record 2
macro ordering confused? 3
Form With Option to Filter or Not 3
Conditional Macro 1
Macro to Close form if no records exist. 2
passing form data onto vba in a macro 1

Top