Remain on Current Record

[billgyrotech]

I tried that but it still reverts back to the first record.

[billgyrotech]

I have removed the Me.Requery and the lines below. This seemed to work great! I thank you so much for your help. I have another question: How can I lock the current record so when the work order is closed, it will be read only and not allow any data to be changed. Could this be a toggle button lock unlock that is password protected to prevent users from altering the data when it is closed?

Thanks,
billgyrotech

[boblarson]

In the form you can put in its ON CURRENT event (assuming you have a field that stores the date closed - I'll call it DateClosed for illustration purposes):

Private Sub Form_Current()
Dim blnAllow As Boolean
 
blnAllow = IsNull(Me.DateClosed)
 
Me.AllowEdits = blnAllow
Me.AllowDeletions = blnAllow
End Sub