Hi! Thanks for your replies! HiTechCoach...I'm with ya! Not good "form" (heh) to let the end user edit directly in a table or query. I sort of inherited this database and have run with it as that's what they like.
I decided to try to just use the Data Macro in the After Update for the table. What I discovered was that the macro is triggered when ANY field in the record of that table is updated. I really just wanted an email sent if a particular radio button is checked off for a record. Apparently, that's not how it works!
I think I'm just going to have to put my foot down and insist that they use a form in continuous view. Then I can control the update event for that particular field.
Thanks for helping me think it all the way through, all!
Melody