asked on MS Access 2003 refresh form on popup form close
My attacjed code looks right.
It opens my popup which I ender some data etc and then close.
However...the underlying form doesn't get refreshed.
It opens my popup which I ender some data etc and then close.
However...the underlying form doesn't get refreshed.
Private Sub btnSubmit_Click()
DoCmd.OpenForm "ClientVisitsPopUp", WindowMode:=acDialog, OpenArgs:=Me.lvClientsNearby.Column(2) & "|" & gbl_VisitClientID & "|" & gbl_NearbyClientID & "|" & Me.gbl_VisitID
Me.refresh
End Sub
Microsoft AccessMicrosoft DevelopmentMicrosoft Applications
Last Comment
Dale Fye
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks
You might also want to capture the primary key from the record you added, and after the Requery method, use the FindFirst method to move the record pointer to that record.