Combo box change to run Macro

[Mary Beth]

I have a combo box on the frmAssessment with a list of Assessors from a
lookup table. I want to send an email to the Assessor who's name is
displayed in the box either when a new entry or a change of names when
editing. I created a macro with a condition of [RNAssessor] = "Jane Doe" and
the action SendObject with Jane Doe's email address - similarly for each
Assessor's name.

The problem I'm having is I cannot get the event to trigger. I tried the
OnChange and AfterUpdate events and they don't work.

Any help you can give me will be much appreciated.

Mary Beth

 

[KARL DEWEY]

A couple of things come to mind --
Is RNAssessor a lookup combo with two columns, the first being a number and
second being text? If it is lookup the condition needs to match the number.

Try have macro pop up a message box to see if it is being triggered but not
sending e-mail.

 

[Mary Beth]

Yes, I do have two columns in the lookup table, the first being an auto
number and the second, the names. I was wondering about this and have
discovered that it works better if you use the number instead of the text. I
used an OnExit event with edit capabilities on the email. It works
beautifully!!! Thanks alot!

A couple of things come to mind --
Is RNAssessor a lookup combo with two columns, the first being a number and
second being text? If it is lookup the condition needs to match the number.

Try have macro pop up a message box to see if it is being triggered but not
sending e-mail.

--
Build a little, test a little.

I have a combo box on the frmAssessment with a list of Assessors from a
lookup table. I want to send an email to the Assessor who's name is
displayed in the box either when a new entry or a change of names when
editing. I created a macro with a condition of [RNAssessor] = "Jane Doe" and
the action SendObject with Jane Doe's email address - similarly for each
Assessor's name.

The problem I'm having is I cannot get the event to trigger. I tried the
OnChange and AfterUpdate events and they don't work.

Any help you can give me will be much appreciated.

Mary Beth