How to undo change of field in another form

[Kayleigh]

I have an order form which includes a combo of different order statuses. When each status is selected it triggers the relevant pop-out form to open. Each pop out form contains a save command and cancel command. My issue is with the Cancel command button - I would like the onClick event to trigger a change on the orders form - that the order status reverts back to its old value. What is the best way to program this?

 

[Uncle Gizmo]

This might help:-

Open one Form from Another and transfer Data - Nifty Access

Passing Form Values A common requirement is to pass values from one form to another. In these videos I demonstrate some problems you might face, and demonstrate a good and robust way of doing it. Open One Form From Another Open One Form From Another Video 1 (3:15) I have used the technique shown...

www.niftyaccess.com

If not, please post a cut down version of your database with any confidential information removed. All that is required is the main form and the Pop-Up forms and any associated tables. Don't need the rest of your database.

 

[MajP]

Depends if you open the form ACDIALOG or not.
If not then on each PopUp add a variable at the top

private callingCombo as access.combobox

then after you pop up the form
the calling form needs to set the callingCombo
set forms("popupformName").callingCombo = me.cmboStatus

In the cancel event
CallingCombo.value = callingCombo.oldvalue

If you are opening ACDIALOG this will not work since you cannot set any value in the called code since execution stops in the calling form.

 

[Kayleigh]

Thank you. Does the input for callingCombo need to be a combo box or can it be a text field?

 

[MajP]

You could do this with any control
Private returnControl as access.control
'the control to reset
set forms("popupformName").callingCombo = me.cmboStatus

In the cancel event
returnControl.value = returnControl.oldvalue

 

[arnelgp]

you can also try to use the OldValue directly:

Forms!FormNotThePopUp!combo = Forms!FormNotThePopUp.OldValue

 

[Pat Hartman]

Seems like a convoluted process. Why open a second form when you actually want to update the original?