Link to home
Start Free TrialLog in
Avatar of shambalad
shambaladFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of jefftwilley
jefftwilley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of shambalad

ASKER

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