REFRESH ON CLICK EVENT

Question

I am using a Sales Order Form which I use as the source for several Reports.  At times I need to update info and then directly run a report, however I've got my 'sort on load' setting for [SalesID] Desc., because I like the form always to be on the latest record on Open, using the default refresh would bring the user back to the newest record.  What I would like to do is create a Refresh Button on Click Event that will not re-sort my records, but rather remain on the current record, so when it is refreshed the user does not have to go back and find the record they were working on.  Any ideas?

Thanks,

js

Answer 1

Set the Me.CurrentRecord first.

CurrentRec = Me.CurrentRecord

Me.Refresh or whatever

DoCmd.GoToRecord acDataForm, "NAME OF YOUR FORM", acGoTo, CurrentRec

Answer 2

  What I would like to do is create a Refresh Button on Click Event that will not re-sort my records, but rather remain on the current record, so when it is refreshed the user does not have to go back and find the record they were working on.  Any ideas?

If pressing the Refresh Button is just a Refresh, and not a Requery, then you can include in the Click event:

      Me.PreviousControl.SetFocus

If the focus was on a control of the current record just before the click, then the focus will return to that control.

Imb.