If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Combo box change to run Macro
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 |
#3
|
|||
|
|||
Combo box change to run Macro
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 |
Thread Tools | |
Display Modes | |
|
|