Subform Link Field Conflict

[smbrush]

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. However, 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 a filter is applied from the main form?

[Beetle]

Cross posted at https://www.access-programmers.co.uk...d.php?t=300074

[Beetle]

@smbrush

If you are going to cross post, please let people know so they can review the other thread to see if a solution has already been provided.

Regarding your current problem, are you able to post a stripped copy of your db that can demonstrate the problem?