I have a form (formA) that opens, a user selects a few values (yes/no checkboxes) and hits save or cancel. These values are then shown as equivalent names on another form (formB) . When Save is clicked on formA, the values are updated on the linked table. (bound form, dynamic recordsource set on FormLoad)
This is what I want to be possible.
- FormB opens (loads from tableB)
- User clicks field that opens formA (loads from tableA)
- changes made to formA
- user clicks save on formA (updates tableA)
- formA closes, bringing user back to formB
- user clicks Cancel on formB
- any changes made to tableA are undone.
Can anyone help?
This is what I want to be possible.
- FormB opens (loads from tableB)
- User clicks field that opens formA (loads from tableA)
- changes made to formA
- user clicks save on formA (updates tableA)
- formA closes, bringing user back to formB
- user clicks Cancel on formB
- any changes made to tableA are undone.
Can anyone help?