I have a form for editing records based on a query. The query is based on a master table. A subform of that form is based on a query that is based on a detail table. The detail table is related to the master by a master ID #.
The user saves changes using an "UPDATE" command button.
The user must exit the form via a command that is button coded like this:
docmd.close acform, "form", acSaveNo
Any info on the form not saved using the UPDATE button is lost. That's how I want it. However, any info entered within the subform is saved no matter what.
How do I get the subform to work like the form? I have tried coding
docmd.close acform "subform", acSaveNo in different events on the subform with no success.