Hi all, I'm new to VB coding and not fully understanding of how a lot of it works yet. I'm certain it's the "On Update" property but I'm not sure.

My database has a form that fills in the time and date at the push of a button. I am then trying to lock the button, making it longer usable for that "CURRENT" record only. I still want it to appear on other records.

The only issue is, my form needs to be manually saved. So if someone accidentaly clicked the Time/Date button then clicked the close button realising their mistake. I'd still need the button to appear next time they went to the record.

I hope this makes sense.

I'm currently using this code behind my button.

"Private Sub btnFillDate_Time_Click()
Me.txtDateOut.Value = Date
Me.txtDepartureTime.Value = Time()
    Me.btnFillDate_Time.Locked = True
End Sub"