Create a query in the front end that appends/updates your comments and run that query from the click event of your save button.
Thanks for the suggestion, but I would be lying if I said "Ok, I will give it a shot."
Actually I did, that's why it has been a day or so before I could reply.
I understand how to create a query, I just don't know how to configure it the way you suggested.
From what I understand, a query only uses data that is already in the database and so the issue I'm having is the comments save button generates the error when clicked, so the comments are not saved in the database yet.
So how do I instruct a query to append/update my comments as you suggested?
You can create an append or update query to use the information from your form.
I haven't used macros in more years than I'd care to admit, so I don't know much about them anymore. Have you tried recreating the macro in the front end? If that doesn't work, let me know if you have any SQL or VBA knowledge. There are several ways to accomplish this and it will help me figure out the best way to help you.