Entering text from a form into an email

[Terkle]

Hi
(I think I posted this originally on the wrong forum so I have re-entered it here and put a reply to this effect on the other forum.)

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

 

[Remou]

You may wish to read this:

http://www.mvps.org/access/lookupfields.htm

It would be best to change the table.

 

[Pampers]

I agree with Remou,
Don't use lookups in tables. The mess up things badly. So get rid of it, and create a combo the normal way....


Pampers
Keeping it simple can be complicated