subforms based on combo/list box selection (1 Viewer)

[stocmamu]

On Form A I have one combo box and one list box. The user will make a selection from each (multiple selections are ok for the list box as well) and this will determine the content of Form B. I could make many versions of Form B based on all the possible selection combinations of the combo and list box but this would take forever. So instead I would like to use subforms on a single Form B that can appear based on what has been selected in the combo and list boxes. Any ideas at how to make this work?

Thank you in advance,
Mark

 

[vbaInet]

my advice would be to use the same subform and programtically change it's recordsource and link sources. apply the code on the change event of the combo box