Getting text into an email

[Terkle]

Hi
I'm hoping someone can help me.
I want to get the text from a combo box on a form into an email. The text that shows in the combo box comes from a lookup table so it is not the actual value. I know that if I type the code:

Me.cboGroup.value

it will give me the underlying value but I want the lookup value to show. Is there any way I can do this? (The combo box uses a lookup value as it is a copy of another combo box where users select a team and it populates automatically based on this selection.)

Thanks

Terk

 

[Terkle]

I meant to enter this in the Access forms forum which I have now done. Please don't reply to this thread.

Thanks

Terk.