Link to home
Start Free TrialLog in
Avatar of peispud
peispudFlag for Canada

asked on

Continuous form....... Would like to have the last 7 records in view after I use command DoCmd.GoToRecord , , acLast:


I am using a continuous form.

DoCmd.GoToRecord , , acLast:     gets you to the last record.

But, when  I programmatically add a record on my continuous form  and use this command,  the only record that I see  is the last record.

I would like to see (by example) 10 records above the last record.
Avatar of PatHartman
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
How about doing a

Open in new window

after you have inserted the record and use the same command to move to the last Record
DoCmd.GoToRecord , , acLast

Open in new window

Avatar of peispud


Thank you for your answers.
PatHartman's answer is a rethink of the problem. Perfect answer!
Here's a little demo of how you can get datasheet and continuous form records into view/position without resorting your records.  Involves the records in subforms.