I have a form with a subreport. The SourceObject property of the subreport is set at design time. The form has a textbox control in which the user can set a filter. The LinkMasterFields and LinkChildFields properties of the subreport are set to the form textbox and the subreport column to be filtered, respectively, using VBA code.
Another form control, an option group, allows the user to change the subreport's SourceObject property. Of course, both queries used to populate the subreport have the same filter column. A problem occurs if the form textbox is set to filter the subreport. The linking column disappears from the subreport. If the filter is removed and the SourceObject property is reset, the lost column reappears. Filters can then be set on the subreport without the loss of the linking column. However, if the SourceObject property is set again from the form, the linking column disappears again.
What can I do to prevent the disappearance of the linking column when the SourceObject property is set while the filter is applied from the main form?
Another form control, an option group, allows the user to change the subreport's SourceObject property. Of course, both queries used to populate the subreport have the same filter column. A problem occurs if the form textbox is set to filter the subreport. The linking column disappears from the subreport. If the filter is removed and the SourceObject property is reset, the lost column reappears. Filters can then be set on the subreport without the loss of the linking column. However, if the SourceObject property is set again from the form, the linking column disappears again.
What can I do to prevent the disappearance of the linking column when the SourceObject property is set while the filter is applied from the main form?
