go to last active id when form is opened or refreshed

[live2ride]

i have main form with everything on it using tabs and so on and everything is working fine.
what i would like to do is this. since im jumping frequently between different records and many actions require main form to be reopened or refreshed and when this happens the form goes to random records, i would like for form to go to last record i was on before it was refreshed or opened.


i was thinking using tempVars to set the id but the problem is that im not sure what can trigger the TempVars since im jumping between the records and not making any changes to them.

any help would be greatly appreciated

[orange]

I don't think you have given enough infomration and context for a definite response but you may have more luck if your form's recordsource was a query that had an Order By .

If you're dealing with so many records in a recordset and jumping around, perhaps you should be doing some sort of recordset processing and using some ordered list of required actions???

Tell us some specifics of your issue and see what the readers say.

[live2ride]

my access is about tickets im working on. i grab the info from our sharepoint site. i do have time table where i record when i start and end working on a ticket but its not something i would like to use since i jump between other tickets while im working on one. my main form is based on active tickets with status of "active" so no query. theres really no order by in this case. havent tried "on close" event but if there as also event like "on refresh" those two would be enough

[orange]

I do not use Sharepoint and have no knowledge of it. But I think you should adjust your subject to include SHAREPOINT.