Defaults to the top of the table after closing form

[ee7]

The database we have at the office always reverts back to the top of the table once we exit out of the form. We will scroll all the way down to the line we need and then click on a form command to change some data. Upon closing, it goes all the way back to the top of the table and we have to keep scrolling back down to get back to the line we were working on. Is there a way to make it so that once we close out of the form it stays on the data line we are working with? Any information would be greatly appreciated. I did not create this database. It was initially created way back in the early ninety's and we just updated it to Access 2007. It did not do this when it was on 2003.

[orange]

Have you considered being more specific when opening the Form

.....where RecordDate = someDate
or
..where CustomerName Like "Smi" & "*"

Just select the record or group of records you need to work with.

[RuralGuy]

You may also find this link useful: http://www.baldyweb.com/Requery.htm

[NTC]

so when a form opens it will go to the first tab stop control - and any lists within controls will return to their defined sort order. that's not a bug - its a feature. To set up some sort of "last visited" style you would need to be entering a time stamp (but that assumes the record is edited and not just viewed) and then you will need a 'Go To Record' code that keys on the maximum time stamp and fires after the form is opened.... So it can be done. Is it an out-of-the-box feature of a database? - no definitely not. hope this helps a little.