I have a continious form based on a query.
When I doubleclick a record I retrieve its recordnumber and then it will be deleted from the query.
When I do a requery the first record is selected but I want to go back to the record with the retrieved recordnumber (that means the record which was right after the record I deleted)
I tried this :
Private Sub Form_DblClick(Cancel As Integer)
Dim clickedRecord as Integer
clickedRecord = Me.currentRecord
'HERE COMES THE CODE TO DELETE THE CLICKED RECORD
Docmd.GoToRecord , , acGoTo,clickedRecord
It gives me error 2105 : Could not go to specified record