Microsoft Access A to Z: Everything you need to know about subforms

This short YouTube covers the how and why of subforms. Subforms are powerful in that they display valuable information on a form -- related data. But subforms are also very misunderstood because they can be created in multiple ways and the properties that connect a subform to a main form are not obvious. In this YouTube we'll create subforms in three ways and examine the key properties that connect a subform to a main form by studying the Link Master Field and Link Child Field properties. We'll also examine the Default View property which determines how a form or subform displays its data.

[cha]

forgot the exact place to click to see the Link Master Fields and Link Child Fields parameters. Thanks to this video I found it again. Thanks Sensei :)

[jim]

Hi Lisa, I'm curious if there's a setting that would allow the subform to display the count of records, but not allow the user to click the left/right arrows to advance. It seems redundant in my situation because there's a vertical scrollbar on the right. I don't want to give up the record count though. :-) For example at around 6:50 your subform shows 3 records. I'd still like to see 1 of 3 but hide or disable the left right arrows.

[satyabanukil]

Respected Madam, your earlier advice on report subtotals was quite helpful to me. This time have a simple query. Suppose i have a main form field called "score", a numeric. In the subform have another similar field with a different name. Now i want to update the subform field "if" the main form field value is greater than 25 (example) which means the subform updates based on the condition of the field in the main form. I tried but not working as I'm probably giving an incorrect syntax. Shall be grateful if advised. Regards

[sharmaneaurora]

Hi, can you please show me a code that will set focus on the first control in the subform when you tab out of the last control in the main form without clearing the data entered on the main form? I tried to set focus on the subcontrol in lastmainfform_lost focus event but it won't work☹️

[bevansmith]

Hi Lisa, I find your tutorials very helpful. Regarding subforms, the Form Wizard doesn't create Combos. I have Students in the main form as Combo box. If I change a text field (Classes) on the subform to a combo box it breaks the connection and I don't seem to be able to get it back. Any ideas appreciated.

[helenarozane]

es jus updatoshu vai es dabusu sekmigi programmesana #pray for me