I'm most of the way to where I want to be, but can't figure out the last step.
I have a form that works on a single table. When the renewal date is changed, I want to set two other fields. That works fine via this:
Private Sub RENEWAL_Change()
If Me.Dirty Then
Me.[last touched] = Date
Me.Select = True
Else
End If
End Sub
What I'd also like if for those two fields, which are on the form, to be reflected on the form while I'm still viewing the record.
As near as I can tell, "last touched" and select are both set as soon as the renewal date is changed, but they don't show up on the form unless I go to the next record and then back up.
Thanks for your help!