How to Create Form with Subforms in Microsoft Access | Edcelle John Gulfan

This video will show you on how to create a form with sub forms in Microsoft access in two different ways.
TWO WAYS:
1. Enforce Referential Integrity
2. Drag and Drop
👍 Please Like comment and share to support this channel
th-cam.com/users/EdcelleJohnGulf...
Downloadable Templates:
• Free Download Template
KEYWORDS
How to create a subform in ms access,
microsoft access, microsoft access database, how to use microsoft access, microsoft access download, microsoft access database engine, microsoft access training, microsoft access free download, microsoft access app, microsoft access application, microsoft access and sql, advantages of microsoft access, about microsoft access
how to link main form and subform in ms access,
How to create forms in ms access,
how to create form with subform in microsoft access, How to create referential integrity relationship, How to Create Relationship in ms access, form with subform in ms access.
how to create subform in ms access, ms access multiple subforms example,
main form and subform in ms access, how to create subform in ms access 2007,
ms access subform within subform, how to create a subform in access 2016,
ms access subform get value from parent form,
add subform in access, what is a subform in access,
microsoft access toturing,
microsoft access tutorial,
microsoft access tutorial for beginners,
software design tutorial,
database design tutorial,
#microsoftaccess
#forms
#microsoftaccesstutorial #mstutorial

[@naymintun8711]

please share lesson video with barcode just like first Form!

[@AT-Nobita1491]

Hi sir. Would like to request tutorial po sana ng katulad sa form na pinakita nyong una dito sa vid. Thank you.

[@EdcelleJohnGulfan]

Ok po sir. Salamat po pala sa panonood.

[@akokohjoel9854]

My brother pls how can I move/copy value from main form to subform. Which bottom with simple VBA code?

[@EdcelleJohnGulfan]

Hi bro. Already answered in my other video. Thanks

[@akokohjoel9854]

@@EdcelleJohnGulfan pls I beg you can you send the Link of the video to watch

[@EdcelleJohnGulfan]

Send me your email. I will give you the copy.

[@EdcelleJohnGulfan]

Or email me at [e-mail]

[@matorwmasen]

Good video, but thought you were going to create it with the bar code functionality, same as your sample video

[@EdcelleJohnGulfan]

I'm just showing the basic way of creating a forms with subform.

[@akokohjoel9854]

Pls look at this, i have a subform, how can it be done, i want to use a subform to update another subform both in this sam mainform?

[@EdcelleJohnGulfan]

Hi thanks for asking. All you have to do is to type the name of the field from the other subform.
Sample: Forms![MainForm]![Subform2].Form![Field1] =me.Field1.value

[@EdcelleJohnGulfan]

and the easy to build that code is the Expression Builder. No need to memorize the pattern.

[@akokohjoel9854]

Pls I want the VBA CODE inside a button on the subform such that it will move/update the Data to another subform both in same main form

[@EdcelleJohnGulfan]

Hi brother.
Same procedure in this video (link below) but you have to use the sample expression above this comment.
th-cam.com/video/pC7hoQe9nxs/w-d-xo.htmlsi=w1yvA-v9HhphKORo