Выдели DoCmd.GoToRecord и нажми F1 .

DoCmd.GoToRecord [ objecttype, objectname ][ , record ][ , offset ]

Аргумент Описаниеobjecttype acActiveDataObject (default)acDataFormacDataQueryacDataTableobjectname A string expression that's the valid name of an object of the type selected by the objecttype argument.record acFirstacGoToacLastacNewRecacNext (default)acPreviousoffset A numeric expression that represents the number of records to move forward or backward if you specify acNext or acPrevious for the record argument or the record to move to if you specify acGoTo for the record argument. The expression must result in a valid record number.

Пример:
DoCmd. GoToRecord acDataForm, "Employees", acGoTo, 7