Avatar of peispud
peispud
Flag for Canada asked on

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

Hi

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.
Microsoft Access

Avatar of undefined
Last Comment
Mark Edwards

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
PatHartman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
John Tsioumpris

How about doing a
Me.Requery 

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

peispud

ASKER
Thank you for your answers.
PatHartman's answer is a rethink of the problem. Perfect answer!
Mark Edwards

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.
RepositionSubformRecords.accdb
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes