Combo box change to run Macro

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

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.


"Mary Beth" wrote:

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

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!

"KARL DEWEY" wrote:

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.


"Mary Beth" wrote:

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