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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Open in new window
after you have inserted the record and use the same command to move to the last RecordOpen in new window