• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

2. Forms > 2.6. Provide Record Navigation Buttons on a Form

2.6. Provide Record Navigation Buttons on a Form

Problem

You’d like to provide some mechanism for allowing users to move from row to row on a form, but you think the navigation buttons Access provides are too small and unattractive. Also, you can’t control when the user can or can’t move to another row.

Solution

Access provides navigation buttons for you to use on forms, allowing you to move easily from row to row. However, you can neither move nor resize these buttons, and you can’t change anything about their appearance.

You can create your own buttons, place them on a form, and have each button use the GoToRecord macro action. Unfortunately, this has two drawbacks:

  • If you attempt to move to the previous or next row and you’re already at the end of the recordset, the macro will fail. The GoToRecord macro action just isn’t smart enough to work in this case.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint