subform subform on main form not refreshing - SourceObject changed the form type

I have 3 subforms on 1 main form.

Forms![frmTC_Detail_Main]![Location Detail].Form![frmTCValues_RightSideDisplay].SetFocus
Forms![frmTC_Detail_Main]![Location Detail].Form![frmTCValues_RightSideDisplay].Requery

What am I doing wrong to refresh the data on the "frmTCValues_RightSideDisplay" subform?

Changed approach using sourceobject, however, on Forms![frmTC_Detail_Main]![Location Detail], mTCValues_RightSideDisplay it changed the form view from continuous to datasheet?  Why??

K
Karen SchaeferBI ANALYSTAsked:
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.

Gustav BrockCIOCommented:
Try with:

Forms![frmTC_Detail_Main]![Location Detail].Form![frmTCValues_RightSideDisplay].Form.Requery

/gustav
Dale FyeOwner, Developing Solutions LLCCommented:
your question implies that you have a subform embedded within the [Location Detail] subform.  Is that correct?

If your subforms are linked using the master/child relationships, you should not need to requery the forms at all.  Simply changing the record in the main form, or in the [Location Detail] form should automatically take care of that for you.  If, however, you have not setup this relationship, then, the requery that Gustave provided should work.
Jeffrey CoachmanMIS LiasonCommented:
It is also not clear what your hierarchy actually is:

I have 3 subforms on 1 main form.
So is it like this?:
  Main Form
  SubForm1,SubForm2,SubForm3
(all three subforms at the same level beneath the main form...)
...Or...
  Main Form
  -->SubForm1
  ---->SubForm2
  ------>SubForm3
Here you have three "nested" subforms

Please clarify

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
Karen SchaeferBI ANALYSTAuthor Commented:
thanks for the input.
Jeffrey CoachmanMIS LiasonCommented:
Kane,
You know me,...If my post did not help directly, ...then I wont seek any points...
My post was just a request for clarification, ...at least Dale and Gustav posted actual solutions.
;-)

Jeff
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.