I did as you suggested, but I was still having trouble. I started over from scratch. I used the DataAssist wizard to create an Update page. That updated all fields as long as I pushed the Submit button. No matter what trigger I selected, I could not get the update query to execute without pressing the submit button. I went through all the drop down triggers the GUI offers, to no avail.
I finally gave up on the GUI and created my own page. See attached. That works. If I remember right, I've never been able to get any of the triggers to work on the update pages created by the GUI. Many of the features I build into my application are not meant for user interaction. Having a trigger that runs the query on page load or if recordset is not empty would make my life easier. I'm willing to work with someone to see what it is that I may not be doing correctly, but for now I had a need to press on and resolve an issue our club was having.