Why no Refresh All option in code?

I am using Access 2007.

I have a situation where information on a sub form of a certain form is not getting updated correctly when retrieving a new record. The solution is simple; I click on the Refresh All button on the ribbon for the form.

I supposed it would be easy enough to do the same in code, but it is not. There is a Refresh option, but not RefreshAll. Refresh (in code) does not fix the problem.  RefreshAll does when I selected it from the forms ribbon.

How does one issue a RefreshAll in code?
WoodrowAAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wiswalldCommented:
requery the subform
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
WoodrowA,

The "Refresh all" option is not available in code because it is a "Hammer"
A brute force option for end users who can't know when or where to requery and/or refresh (Or even what the difference is)

To use this in code would be sloppy and time consuming, because it requeries everything, whether it needs it or not.
For complex forms this can take a long time.
(Would you want your mechanic to bill you for changing all 4 tires if you only had a blowout in one of them?)
;-)


"Refresh (in code) does not fix the problem."
You should have tried "ReQUERY".
You also did not say where or when you used it?

I'm with wiswalld:
  "requery the subform"

JeffCoachman
0
WoodrowAAuthor Commented:
Thank you both
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.