Need to update records immediatly 1

[carlp69]

I have a form with an option box "Frm_PayMethod" that has two option buttons. The option box has an 'OnClick' event.
The event has the following code :-

If PayMethod = 1 Then me!Status = "Pay In Full"
If PayMethod = 2 Then me!Status = "Pay SSP Only"
Me!Frm_PayMethod.SetFocus

When I click on either of the options it changes the status on the screen but has not commited the status to the table.
How can I force the table to commit the 'Status' Field immediatley when the options change?

Thanks

 

[neemi]

Hi Carlp69,

try the following:

If PayMethod = 1 Then me!Status = "Pay In Full"
If PayMethod = 2 Then me!Status = "Pay SSP Only"
docmd.RunCommand acCmdSaveRecord
Me!Frm_PayMethod.SetFocus

Hope it helps
Neemi

 

[DedCat]

Can this be done in the mcro builder? I've been using the 'GoToRecord' Next function. this works great until i reach the last record on the form.