Solved

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

Posted on 2007-04-04
5
187 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

863 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

18 Experts available now in Live!

Get 1:1 Help Now