Only by using a form. Preferably the AfterUpdate event. See the
Access Email FAQ at my website for various methods of sending emails.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm