Combo box change to run Macro

  • Thread starter Thread starter Mary Beth
  • Start date Start date
M

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
 
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.
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top