[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

With continuous form, set up command button to move the cursor to the next row

I'm sure this is easy, but.....
I am working with a data entry continuous form. I would like to set up a command button in the form footer to move the cursor to the next row. What would be the VBA behind the command button's click event?
I am using Access 2003.
Thanks
0
shambalad
Asked:
shambalad
2 Solutions
 
jefftwilleyCommented:
DoCmd.GoToRecord , , acNext
0
 
Rey Obrero (Capricorn1)Commented:
to get rid off error when in the last record

private sub commandBtn_click()
on error resume next
docmd.gotorecord,,acnext
end sub
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You can you know ... just as well use the built in navigation buttons ... the advantage being that all the error trapping is built in ... along with being grayed out at the appropriated times, plus buttons to move Back, First, Last and New ... in addition to Next.

mx
0
 
shambaladAuthor Commented:
mx - the reason for the command button is to enable a keyboard shortcut.
jefftwilley, I am accepting your answer; with an assist from Capicorn1 (since his is the exact code that I am using).
Thanks to all,
Shambalad
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
No problem.

mx
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now