Navigate a Recordset With a Userform – Part I

This is the first of a four-post series that will describe how to connect a Userform to an ADO Recordset. The end result will be similar to an Access form where you can go to the previous record, next record, etc. It will not show how to update the recordset, although if I’m feeling froggy, I might add a Part V.

Part I – Set up the userform
Part II – Special purpose Sub procedures
Part III – Set up the Recordset
Part IV – Code the buttons to navigate the Recordset

Set Up The Userform

ufado1

Set up this userform

ufEmployee
    Caption = Employees

From top to bottom, left to right, set up these controls

tbxEEID
    Tag = Field0
tbxLastName
    Tag = Field1
tbxFirstName
    Tag = Field2
tbxBirthDate
    Tag = Field3
tbxHireDate
    Tag = Field4
cmdFirst
    Caption = < <
    Tag = ButtonFirst
cmdPrev
    Caption = <
    Tag = ButtonPrev
cmdNext
    Caption = >
    Tag = ButtonNext
cmdLast
    Caption = >>
    Tag = ButtonLast

Now save this workbook and tune in for Part II where we’ll create a couple of special purpose procedures to manage the Userform.

One thought on “Navigate a Recordset With a Userform – Part I

Leave a Reply

Your email address will not be published. Required fields are marked *