The Refresh Button....?

[djclntn]

Quite often I use the "Refresh" button in my Forms to update my data. The problem is, when I click on the Refresh button it takes me back to the first record in my Form; I may have over 800+ Records. Is the any way I can cinfigure Access to when I click on Refesh it goes to the last Record vs. to the first Record?



Thanks

[pbaldy]

One way:

http://www.baldyweb.com/Requery.htm

[djclntn]

I'm sorry, but I don't follow how to go about writing a command for what you suggested. I followed your link to your site, read the instructions several times & even viewed the ReQuery dbs. I'm not at all a "programmer" & require some more help if you're willing.

Thanks thus far.

[pbaldy]

Why don't you post your db, or a representative sample, and we'll figure out what you're doing wrong?

[Stingaway]

If you can place a descending sort in your original query on any field (date comes to mind) then you should be okay... by default I don't think there is a general option that sets the value of the refresh in any particular order other than record view (first to last). Refresh is used in queries, tables,, forms, etc.. so I would doubt there would be a default. (Could be incorrect though... it happens..)

[Mclaren]

this is what i use:

DoCmd.GoToRecord , , acLast

[pbaldy]

If you don't have your answer, you may want to clarify the goal, as some of us are interpreting it differently. Does "last record" mean the last record in the recordset or the last record you were working on (which may or may not be the last record entered)?

[Stingaway]

yeah you could set up a button to do a refresh/requery and then use Mclaren's idea...

[djclntn]

Guys, Thank you for all of your help & imput, really! There is a very simply solution to my inquiry which olny takes 1-sec. If I'm working in a Datasheet Form & when I want to Refresh, in order to return back to the last Record on the Form I simply click on the last Record button on the bottom. Not to be smart, but I feel like a fool & wonder why nobody suggested this simple method. Yeah, it would have been nice that when I click the Refresh button it goes to the last record on the Form vs. the first Record, but I can live without that wish.

Thanks pd & all!

[pbaldy]

wonder why nobody suggested this simple method.

Perhaps because you asked "Is the any way I can cinfigure Access to when I click on Refesh it goes to the last Record vs. to the first Record". "Configure" implies a built-in or programmatic solution, not a "tell the user to click on whatever" solution.

[djclntn]

Fair Enough & point indeed well taken