keep old text patch also new text

[DAVIDPOWELL]

I have 4 textboxes on a screen, no form.

I have a button on the screen.  patch is on this button

What I need:

If i change the value in the textbox i need to retain the old value

Then

and also patch my new value into a table?

is there a better way ?

Right now i'm doing this:  Using labels to store the old value but hidden from view.

Patch('[dbo].[Base_Information]',LookUp( '[dbo].[Base_Information]',
ID_Num = Value(ID_NUM_LBL.Text)),
{ OLD_QB_NAME: Current_qb_lbl.Text,

NEW_QB_NAME: NewQb_name_ddwn_cbo.Selected.EMPLOYEE_NAME,
OLD_QB_RACFID: racfid_qb_lbl.Text,
NEW_QB_RACFID: NewQb_name_ddwn_cbo.Selected.user_id

}

)

Thanks

Dave

[RandyHayes · Accepted solution]

@DAVIDPOWELL 

Please consider changing your Formula to the following:

With({_oldRecord: LookUp('[dbo].[Base_Information]', '[dbo].[Base_Information]', ID_Num = Value(ID_NUM_LBL.Text))},

    UpdateIf('[dbo].[Base_Information]',
        ID_Num = Value(ID_NUM_LBL.Text),
       { OLD_QB_NAME: _oldRecord.NEW_QB_NAME,
         NEW_QB_NAME: NewQb_name_ddwn_cbo.Selected.EMPLOYEE_NAME,
         OLD_QB_RACFID: _oldRecord.NEW_QB_RACFID,
         NEW_QB_RACFID: NewQb_name_ddwn_cbo.Selected.user_id
       }
    )
)

I hope this is helpful for you.