How to Retrieve Values on a Subform from a Parent Form and Vice-Versa in MS Access

Sometimes when you're developing forms in MS Access, you need to get particular value from a subform, or a value from the parent form. This can be tricky, but in this episode I'll show you several ways that you can reference values in your subforms or parent forms. You can use VBA that is running on the form's code, or you can use epxressions in text boxes. Let's go take a look at how to do our subform and parent form value lookups!

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

For developers looking for a new role, check out:

Needing to hire technical resources for your project? Get the best:

[ledahbernardi]

Thank you, for your class, just amazing. I´d like to watch the lesson, where you build this orders_form, can you inform the link? I need to count, my subform, the way I saw in your subform order items. Thank you a lot.

[jobyjohn]

Thank you so much. You saved my life. 😊

[satyabanukil]

Wonderful presentation Sir. Learnt a lot from the tutorial. Can I update any subform field based on a field on the parent form with "if" condition.

[richardmeborg]

Hi. I have built a database, whict I have pricing of a product, where i calculate aall the ingredience to become a full productr to sell.
That price i get out theree, I would lioke to automatacally be shown in the actually product form without linking those tw form that has nothing to do with each other.
Please can you help me?

[akokohjoel]

thanks for your video. Pls from the video how can one update data from one subform to another subform.
That's a value in subform A can move to subform B. What vba code will do that by clicking or double clicking ?

[rohancorea]

Sean I appreciate all your video tutorials. I have a request. Can you do a video on how and when to use Bang ! and Dot . It is not very clear to me. Thanks

[stanTrX]

Thanks. I want to show some additional calculated data for display purposes only for my query fed form but probably due to the additional joins it is not unupdateable. What might be the solution? I want these to be seen on the same row. What i think maybe a side by side subrows which are perfectly aligned or maybe a vba event which will change the row source of the field for the fields which shall be updated.

[faez]

Thank you so much! this helped me a lot.

[satyabanukil]

Good Morning Sir. So far I had been working with single table as I was not conversant with relationship. Anyway this time created two tables having "PAIR", a numeric field. Made a relationship between the tables with PAIR as primary key in parent form. I want to fetch all data from parent form to rows in a linked tabular form where PAIR in form 1. For example if in the first page of parent form shows PAIR =1 then it will automatically show 1 in the tabular form. It is a separate form and not a sub form. I followed your tutorial but shows error. Then I tried with DLookUp but this cannot be applied when parent form PAIR changes. So when you get time, kindly present a tutorial on this problem. Thnx and regards

[navisalomi]

thanks for sharing. really useful tool 😎

[satyabanukil]

Suppose I have single table database and having five forms under one table and each form has a field "Total" representing each person. Now I want to create another form in which I want the sum of all five individual form totals with where condition e.g. grand total against a particular individual. If should be possible but I don't know how to do that. Sir if you get time, kindly make a tutorial on it for which I shall be grateful. Regards.

[tummalatube]

Suppose My form can be used as standalone form as well as a subform. When it is used as a standalone form, Me.Parent is failing even while validating if parent exists. How to meet this scenario? Thanks. I am a subscriber to your channel and a regular follower.

[chaudhrypoultry]

Hello 👋 👋 Hi dear sir
I want to undo subform from the parent form plz help me.

[artistryartistry]

Can you please consider making a video on how to link two subforms? :)

[marcelodineck]

Hi I tried it but I still having error, I am try call the subform and seems is not referenced correctly Error 2450 or 2465. Could you suggest anything? I put the pictures here: