Access 2000 continuous form scroll - TechRepublic
General discussion
January 1, 2003 at 07:01 AM
rnbmeares

Access 2000 continuous form scroll

by rnbmeares . Updated 23 years, 5 months ago

In access 2000 I’ve created a continuous form where 3 detail records show in one form view. I would like to create a command button that would not only move to the next record but to move 3 records at a time putting the “moved to” record to the top of the form.
I’ve currently created a command button using the following VB: “DoCmd.GoToRecord , , acNext, 3”
My Problem is: Though this command moves 3 records at a time it does not put the “moved to” record to the top of the form so that the user can view the next 3 records. Is there a way for me to accomplish this?

Thank you for you help and the time you take to help people like me out.

This discussion is locked

All Comments