If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pause Subform
Hi,
I have a main form with a bunch of subforms. Each subform is built on its own query. Each subform has a combo box that is bound to a field in the query. What happens is that if I change a value in one combo box (in one subform) then go to a control in another subform, the first subform already commits to the table! The value is saved. If I hit ESC, the new value is still there. I want to have a SAVE button and CANCEL button at the bottom of the main form, so the user can undo all their changes to the main form and all the subforms. How can I do that if the subform already committed the changed value? Thanks!! John Schping |
#2
|
|||
|
|||
Pause Subform
It may take changing the design of the form. When you move the focus from the
MainForm to a SubForm, the mainForm *will* save a Dirty Record. The same thing happens in the reverse direction. When you move the focus off of a SubForm, it *will* save a Dirty record. jschping wrote: Hi, I have a main form with a bunch of subforms. Each subform is built on its own query. Each subform has a combo box that is bound to a field in the query. What happens is that if I change a value in one combo box (in one subform) then go to a control in another subform, the first subform already commits to the table! The value is saved. If I hit ESC, the new value is still there. I want to have a SAVE button and CANCEL button at the bottom of the main form, so the user can undo all their changes to the main form and all the subforms. How can I do that if the subform already committed the changed value? Thanks!! John Schping -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
#3
|
|||
|
|||
Pause Subform
Hi,
How would you suggest redesigning the form? I have separate queries for each subform since I'm working with related tables, and one-to-many relationships. I can't put it all in one form, unless I am missing something. Please help! Thanks so much, John Schping "ruralguy via AccessMonster.com" wrote: It may take changing the design of the form. When you move the focus from the MainForm to a SubForm, the mainForm *will* save a Dirty Record. The same thing happens in the reverse direction. When you move the focus off of a SubForm, it *will* save a Dirty record. jschping wrote: Hi, I have a main form with a bunch of subforms. Each subform is built on its own query. Each subform has a combo box that is bound to a field in the query. What happens is that if I change a value in one combo box (in one subform) then go to a control in another subform, the first subform already commits to the table! The value is saved. If I hit ESC, the new value is still there. I want to have a SAVE button and CANCEL button at the bottom of the main form, so the user can undo all their changes to the main form and all the subforms. How can I do that if the subform already committed the changed value? Thanks!! John Schping -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 . |
#4
|
|||
|
|||
Pause Subform
I don't really know. Undoing the changes done in a SubForm can get real
tricky. It would be better to design the form(s) in such a way that the undo became unnecessary or was more simplified. jschping wrote: Hi, How would you suggest redesigning the form? I have separate queries for each subform since I'm working with related tables, and one-to-many relationships. I can't put it all in one form, unless I am missing something. Please help! Thanks so much, John Schping It may take changing the design of the form. When you move the focus from the MainForm to a SubForm, the mainForm *will* save a Dirty Record. The same [quoted text clipped - 18 lines] John Schping -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
Thread Tools | |
Display Modes | |
|
|