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

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

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

(Need Code To Replace Macro) Thanks.
Thanks,

Dave
 
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.
 
Back
Top