ntsabman
asked on
Access 2010 Opening a form to the lat record
When i open a form i want it to be at the last record
and that the user is able to move after the opening from one record to another
and that the user is able to move after the opening from one record to another
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jeff,
That is a good point. Understanding what "Last" means is important. As you pointed out, depending on the sort order of the recordset, the last record can be different.
To insure that the sort order does not get changed I also clear any filter when the form closes. I find this to be more efficient that setting the sort order every time the form opens.
That is a good point. Understanding what "Last" means is important. As you pointed out, depending on the sort order of the recordset, the last record can be different.
Then reset the sort to this each time the form is opened.Since I deploy all my front ends compiled (mde/accde) then sort order will always be the same when the for opens.
To insure that the sort order does not get changed I also clear any filter when the form closes. I find this to be more efficient that setting the sort order every time the form opens.
Thanks,
As you know, I never like to speak in absolutes...
It is always best to know multiple techniques and points of view...
<To insure that the sort order does not get changed I also clear any filter when the form closes. I find this to be more efficient that setting the sort order every time the form opens. >
Every day is a school day...
;-)
Besides, your post answered the question precisely as posted.
;-)
Jeff
As you know, I never like to speak in absolutes...
It is always best to know multiple techniques and points of view...
<To insure that the sort order does not get changed I also clear any filter when the form closes. I find this to be more efficient that setting the sort order every time the form opens. >
Every day is a school day...
;-)
Besides, your post answered the question precisely as posted.
;-)
Jeff
Jeff,
;-)
Boyd
Every day is a school day...It sure is ....
;-)
Boyd
ASKER