Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to use 'GoToRecord' Command to get a record by Primary Key- VBA Acess 2010 [closed]

How to use 'GoToRecord' Command to get a record by Primary Key?

like image 955
Padawan Avatar asked Sep 04 '12 04:09

Padawan


1 Answers

I suspect you wish to move to a record given the primary key.

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

    If .NoMatch Then
        MsgBox "Not found"
    End If
End With
like image 51
Fionnuala Avatar answered Nov 15 '22 07:11

Fionnuala