About
Pricing
Community
Teams
Start Free Trial
Log in
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
asked on
11/6/2017
Refreshing A subform
Hi
Kindly advise whether the code below can refresh the sub form properly:
Private Sub Refresh_Click()
DoCmd.Save
DoCmd.Close
Docmd.Opern Form " Accounts"
End Sub
I have tried the Me.Requery nothing seams working up
Regards
Chris
Microsoft Access
5
1
Last Comment
Pawan Kumar
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Pawan Kumar
11/6/2017
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
11/6/2017
ASKER
On after update event??????????
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
11/6/2017
ASKER
Or do you mean like this
Private Sub Refresh_Click()
DoCmd.Save
Me.yourSubFormConyrol.Form
.Requery
End Sub
Pawan Kumar
11/6/2017
Yes.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Pawan Kumar
11/6/2017
Hi,
You need to select my comment and then click on the submit. That's the way we close the questions.