Refresh form, but remain on current record 1

[emilybartholomew]

Is there a way to refresh the contents of a form, but remain focused on the current record? Or is there a form function where you can jump to a particular record (i.e. saving the record id, refreshing, then jumping back to that record)?
I'm using Access 2000.

 

[BillPower]

Try using this instead of implicitly Refreshing the Form or Sub Form (Assuming that you're not already using this):

DoCmd.RunCommand acCmdRefresh

Good Luck

Bill

 

[emilybartholomew]

Can you use this to refresh a form other than the one that the code is running from?

 

[emilybartholomew]

Never mind- I figured it out. I created a subroutine on the form that I wanted to refresh (with your code as the body of the subroutine), and then called the sub from the other form. It works great - Thanks!!!!!

 

[BillPower]

To Refresh another Form, use:

Forms!TheFormName.Refresh

The Form you are attempting to Refresh must of course be open.

DoCmd.RunCommand acCmdRefresh will refresh the Form it is being called from.