Making record inactive

[poppconsulting]

I need to keep every record that a user deletes, but set it's status to inactive. I have done this, but now when the user marks this record inactive, how can I refresh the form (I am filtering to view only "active"), but capture the bookmark of the previous record, so that record displays, not the first record in the recordset?

[missinglinq]

I do a similar thing in an app I'm working on, and this works for me:

Private Sub cmdDeleteRecord_Click()
Dim bk As String
 
  If CurrentRecord <> 1 Then
 
 DoCmd.GoToRecord , , acPrevious
 
    bk = Me.Bookmark
 
    DoCmd.GoToRecord , , acNext
 
    'Place your code to mark record inactiver here
 
    Me.Requery
    Me.Bookmark = bk
 
  Exit Sub
 
  Else
   'Place your code to mark record inactiver here
    Me.Requery
End If
End Sub
 

Welcome to TheScripts!

Linq ;0)>