use same subform 3x on form

[stormin_norm]

Main form has a listbox for custid once selected three subforms should populate with profile1, profile2, profile3.
I do not wish to create three seperate subforms, simply re-use the same subform and filter as:
subform1 filter profile=1
subform2 filter profile=2
subform3 filter profile=3

Should I do this dynamically --- use one of the events on the custid listbox to trigger the filtering of the subforms.
OR
Should I simply use three different queries as the record source

Need some details on doing either.

 

[stormin_norm]

Looks like the only way is three seperate queries, and changing the subform recordsource.

Any other ideas/comments?

 

[dcx693]

You can use a Tab control, have a different subform on each sheet of the tab if you don't want to swap out a single subform recordsource.

 

[stormin_norm]

It is important to view all the profiles on one screen, they are not large so they will fit. I just thought there would be an easy way of reuse of the same subform vs. having three different subforms tied to three different queries.