Using other information from a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box that I use to select an associate and I want to email that
associate a message.

I've set the record source to:

SELECT ID, Name, EmailAddres ....

And the field count to 3 and the widths to 0;2;0.

Using an After_Update Event, can I access the EmailAddress?

I thought the syntax was cmbAssociate(2) to get the email address but I get
a Datatype Mismatch error when the code runs? Is this syntax correct?

TIA

Mark
 
Back
Top