Don’t Use Default Properties When Working with Hierarchical Recordsets

It’s common VB knowledge that you can omit the default property of a control or an object. For example, statements such as Text1.Text = “blah” and Text1 = “blah” are equivalent, with Text being a default property of text control. Objects behave similarly. When you have two tables, Orders and Items, in a parent-child relationship by OrderNumber, you can build a hierarchicalrecordset that stores Items