I have a form with a combobox that selects a category (cboSelectType). It is pulling its list from a table with 2 fields. Key field is form names and displays the category name in the combobox. But the actual values it holds are form names.
There is a subform on this form where I want a form for the selected category to be loaded (sub_SelectType).
In the BeforeUpdate for the combobox I have the following....
Dim src As String
src = Me.cboSelectType
Me.Sub_SaleItems.SourceObject = src
It works except that there are no records. In my experience. This is because the LinkChildFields and LinkMasterFields Properties are auto set to something. I need these to be blank.
So my question is... How do I make LinkChildFields and LinkMasterFields properties Blank?
Me.Sub_SaleItems.LinkMasterFields = "" did not work.