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.

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!

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.

Thank you that helped me. Craig

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

Nice video. Thank you.

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

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?

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!

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