D Dave Elliott Sep 1, 2003 #1 [Forms]![FPayments]![Status] (1) "Paid" (2) Save Record (3) Requery (4) (Need Code To Replace Macro) Thanks. Thanks, Dave
[Forms]![FPayments]![Status] (1) "Paid" (2) Save Record (3) Requery (4) (Need Code To Replace Macro) Thanks. Thanks, Dave
W Wayne Morgan Sep 1, 2003 #2 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.
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.