Access Form With a Subform and Calculated Fields

In this tutorial I show you how to create a Form & a Subform & link the Subform to the main Form. We'll create Relationships between tables, then create a multi-table query. We'll be adding a logo and 4 calculated fields. Along the way, we'll create a Combo box and control some Form properties.

To be notified when new videos are published, make sure you subscribe to this channel... Your comments are always appreciated.

[ricardomontoya]

Have a program to write to account for my Church's contributions, your video shows me everything I need to get started. Thank you so much.

[rajeshsanghvi]

Nabil -Best instructions. Very clear. Thanks for this.

[dewaldkritzinger]

BRILLIANT!! THANK YOU. Easy to understand and follow and no steps missed or "assumed". First time, all GOOD.

[abbasial]

It was the best access tutorial that I have ever seen. thank you. excellent

[sadaquathussain]

Thank You so much sharing such kind of fruitful video on MS. Access.. Mr. Nabeel Murad you have has good grip on Access and explained all concepts of form & sub form in very professional way.

[leonshears]

Very good! Everything I need to know - except "tabbing". I was hoping to learn how to tab from the main form on to the subform (2 consecutive fields) and back to the main form. But apart from that, again, excellent! Thank you

[nationalprayerroom]

Thanks so much for this. I have been trying to figure out how to put totals from a subform for a long time. Thanks for the great work.

[polaterol]

Well done.. The best on Forms.. There is only one area you should be careful.. in the creation of Subform you deleted the RetailerID .. but some how it came back when you connected the subform to the mainform..

[johncobbina]

I haven't come across such a tutorials before. You done a good job.

[paulstanlev]

Fine Thank you Sir. you Great, special and nice for Teaching...

[dorothy]

The tutorial looks great and very simple!

[zsdeb]

Thank you Sir, this was, and still is an amazing tutorial!

[jungjungdelosreyes]

Wow...pls continue to use this same database as you progress your tutorial. I like everything on your tutorial very straight forward and faster, because some tutorial is too sleepy and boring. But this one excellent. Im looking forward the progress on this same database. Thank you sir.

[vijaysarvaiya]

What nice and clear instructions... thank you sir..

[adriannaparedes]

The best explanation, thank you very much 😁

[jamesowusu]

Great presentation. Thank you
Please i need your help
I created two forms from two different tables. i want to enter only the PatientID from the first form so all the remaining patient details will be filled in the second form. How can i do that? i will be grateful if you can help me.

[ashokanselliah]

Thank you so much. I really enjoy your video and it is really helpful.

[pratchmg]

Thank you. That was extremely informative and has helped me a lot.

[ammadkangatabdulla]

excellent, clear and interesting tutorial

[moneementor]

I'm having trouble making the relationships among the tables and what foreign fields need to be in them. Any help? Thank you