CODEWITHSUNDEEP
ms-accessvbams-access-2010ms-access-2013
Marchese Il Chihuahua
Marchese Il Chihuahua

Reputation: 1137

Go to first record function

I would like to know the feasibility of writing a routine which allows for the user scrolling through a single form when arriving at the last record to be able to continue scrolling at the first record in the form. Basically i want to make one button that allows the user to be able to endlessly scroll through his records. It it possible with code? Perhaps there is already a function in MSAccess allowing for this to happen? Thanks

Upvotes: 1

Views: 9539

Answers (1)

Marchese Il Chihuahua
Marchese Il Chihuahua

Reputation: 1137

It appears i worked it out. .Thanks anyway

If CurrentRecord = Recordset.RecordCount And CurrentRecord <> 1 Then
    DoCmd.GoToRecord , "", acFirst
Else
    On Error GoTo cmdRecordSuccessivo_Click_Err
    DoCmd.GoToRecord , "", acNext

cmdRecordSuccessivo_Click_Exit:

Upvotes: 3

Related Questions