Set Status, Save Record, Requery. SEE Statement Below (Macro).Need Code to Replace.

[Dave Elliott]

[Forms]![FPayments]![Status] (1)
"Paid" (2)
Save Record (3)
Requery (4)

(Need Code To Replace Macro) Thanks.
Thanks,

Dave

 

[Wayne Morgan]

I am assuming this is to run when the Status is changed. If so, in the AfterUpdate event
of the Status control try something similar to:

If Me!Status = "Paid" Then
RunCommand acCmdSaveRecord
Me.Requery
End If


Be aware that the Requery will return you to the first record of the form.