Solved

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

Posted on 2007-04-04
5
186 Views
Last Modified: 2007-04-04
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
Comment
Question by:shambalad
5 Comments
 
LVL 34

Accepted Solution

by:
jefftwilley earned 400 total points
ID: 18850584
DoCmd.GoToRecord , , acNext
0
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 100 total points
ID: 18850634
to get rid off error when in the last record

private sub commandBtn_click()
on error resume next
docmd.gotorecord,,acnext
end sub
0
 
LVL 75
ID: 18851260
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
 
LVL 7

Author Comment

by:shambalad
ID: 18851487
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
 
LVL 75
ID: 18851517
No problem.

mx
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now