GoToRecord Doesn't Work in SQL Linked Table

[Kate Koun]

I have linked SQL Orders and OrderItems tables. On an
order form, I am deleting a record from an orderitems
subform. The following code worked before I upsized to
SQL:

Private Sub Form_AfterDelConfirm(Status As Integer)
On Error GoTo err_Form_AfterDelConfirm

Dim LastRecordLineNum As Integer
Dim StartingRecordNum As Long

StartingRecordNum = Me.CurrentRecord

DoCmd.GoToRecord , , acLast
...

Now, when I reach the GoToRecord command I get a message
box saying "Can't go to specified record". I assume this
has something to do with having just deleted a record as
the command works find when inserting a record. Any ideas
on how I can get this functionality back?

Thanks

 

[Michel Walsh]

Hi,


Have you tried:



Sub MoveToTheLastRecord( )
With Me.RecordsetClone
.MoveLast
Me.Bookmark = .Bookmark
End With
End Sub



(don't miss the small dots, there is one before Movelast and one, more
visible, before the right Bookmark).



Hoping it may help,
Vanderghast, Access MVP