Refresh Record and keep open on AfterUpdate event

A

Alex

I have two tables joined by RefField. After I change RefField on my input
form, there are several fields from one of the tables that will change. I
understand that on the AfterUpdate event of the RefField control, if I write
If Me.Dirty Then Me.Dirty = False then the record will be saved. What I need
is for the record to refresh and show the updated values.

If I write:
If IsOpen("Inputfrm") Then
Forms!Inputfrm.Refresh
Forms!Inputfrm.Requery
DoCmd.OpenForm "Inputfrm", acNormal, , strWhere

Then the form will refresh just as I need it to, but it jumps to the first
record.

Is there a way to get the form to refresh, show the updated values and stay
open to the record it’s already on? I have been struggling with this and
have posted a couple other times. Thanks much.
 
Top