How to Get a Value from a Subform in Microsoft Access

[@Richard.E84]

Hi Richard, your videos are by far the best I have watched on Access, I've gone from complete clueless beginner to building my first access database purely on your lessons.

[@rogerstrate5727]

Thanks so much Richard, I have had this question on my mind for several weeks and you nailed it perfectly for me in this video. I certainly appreciate you and all I continue to learn with Access you are my hero.

[@599CD]

Fantastic!

[@rogerstrate5727]

@@599CD Thanks again!!!

[@khia555]

Are you spying on me? I feel like you’re spying on me! Every time I run into a problem you come out with a video that’s the exact answer to what I need! Loving your content ^^ thank you so much for all you do!

[@599CD]

Always watching... always judging...

[@craigmeyer7494]

Thank you that helped me. Craig

[@599CD]

Glad it helped

[@ramiraghat8496]

Nice video. Thank you.

[@599CD]

Welcome

[@mosjany]

Thanks for this class its great....but I have one headache > how to I collect invoice payments, able to see invoice balances if paid partial etc please if you can assist

[@599CD]

I cover partial payments in 599cd.com/ACD7

[@compa1314]

Great Content as always. QUESTION: How can I go about showing outside the subform a DetailSummary where I see All Product Quantity + Name? I tried DetailSummary=[Quantity] & " " & [Name] & " + " in subform footer. And then referenced from parent form with =[frmSubSalesOrders_Details].[Form]![DetailSummary]. The footer field comes out perfectly to from the subform to form. But I cant get the Subform footer to concatenate the Name and Quantity further than the first field from the datasheet subform. Can you think of any way to iterate through the subform datasheet entries whilst concatenating? THANKS!

[@599CD]

599cd.com/Ask

[@albyluchko6030]

hi Richard - thank you for all the video tutorials! My question is this: I created a continuous form with search boxes as you explained in another video. Works GREAT! I was trying to insert that form (ResearchersListF) as a subform into another form but it doesn't connect the search fields in the query (which references the textboxes in the form e.g. Forms!ResearchersListF!FnameSearch). I get pop ups asking for the values for the search fields whenever it runs the query. the query can't find what it needs. Am I not allowed to use a form also as a subform? I preferred embedding the list of researchers and its search functions into this other form rather than popping open another form/window, but I certainly could if I had to. I hope that makes sense. Basically, can I create a form the relies on a query (as its own form) and also use it as an embedded subform in a different form?

[@albyluchko6030]

I should clarify - it appears it's just the search that doesn't work. Right now, as an embedded subform, it is passing back the ID of the research I choose if I navigate through the list. But the search doesn't work. When I open the main form, it is asking for the values for all the search box fields. And if I try to search, the pop ups come again. The search works fine with when the form is opened on its own. thanks!

[@599CD]

599cd.com/ask

[@paulojorgecasanova]

I liked this code to fetch values from the sub-form to the parent form: Dim valor As String 'Get the value of the "Nº série" field in the subform valor = Me.SubComp.Form.Nº_série.Value ' Assign the value to the "SN" field in the parent form Me.SN.Value = valor

[@599CD]

If it works, it works.

[@robertodc62]

=[Ventas02].Formulario![Texto68] in the parent form or =Formularios![Ventas01]![Ventas02].Formulario![Texto68] in eny other open form

[@599CD]

Uhm... OK. :)