How to use the GoToRecord command to get a record by the first key - VBA Acess 2010

Question

How to use the "GoToRecord" command to get the record by the first key?

+5

Padawan Sep 04 '12 at 4:02

1 answer

Fionnuala · Answer 1 · 2012-09-04T08:56:22+0000

I suspect you want to go to the primary key entry.

MyKey = 3
With Me.Recordset
    .FindFirst "ID=" & MyKey

    If .NoMatch Then
        MsgBox "Not found"
    End If
End With