Solved

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

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

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access 2007 Switch To/Retry/Cancel Pop-Up 6 30
Restoring a form to its default settings 3 27
FrontEnd tools to create web database application 7 55
Access on Mouse move 5 31
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

776 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