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.
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
Last Comment
Mark Edwards
ASKER CERTIFIED SOLUTION
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
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 questionASKER
Thank you for your answers.
PatHartman's answer is a rethink of the problem. Perfect answer!
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.
RepositionSubformRecords.accdb
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
Open in new window
after you have inserted the record and use the same command to move to the last RecordOpen in new window