I have a form frmReportGenerator with several pages (tabs). It contains functions to customize reports and email them out.
The pages have subforms, including frmSubViewEmailMsg for maintaining the email messages.
The recordSource for this form is table tblEmailMessage. This table has 3 memo fields: TerminatingMsg, ExceptionsMsg, BothMsg. The form displays these fields in 3 textboxes:
On this form, the textboxes are view only (locked). To allow the user to edit them, there is a command button (“EDIT”) next to each textbox. When the user clicks on the EDIT button, it opens up a popup form frmSubEmailMsgEdit that has a textbox containing the message text. On this form the textbox is unlocked to allow the user to edit, then save the changes to the message text.
I am having trouble figuring out how to pass the name of the message type so that the changes can be saved to the correct field in the table tblEmailMessage. I’m already passing the message text using the arguments of the DoCmd.OpenForm command. What am I overlooking here??