Different Subforms based on Query Criteria

[Deuce Sapp]

I am trying to create a "Workorder" form based on an equipment list and I
want the subforms to be different based the "Type" field in the equipment
table. How can I show or not show subforms (and position them?) based on
that result?

__________________________________________________________________ Deuce
Sapp __________________________________________________________________

 

[John Vinson]

I am trying to create a "Workorder" form based on an equipment list and I
want the subforms to be different based the "Type" field in the equipment
table. How can I show or not show subforms (and position them?) based on
that result?

One efficient way to do this is to use just *one* Subform control, but
change its SourceObject property to whichever form you need for this
particular record. You'll need some VBA code in the AfterUpdate event
of the control that picks the Type, and perhaps a consistant naming
convention for the forms (or else store the formaname in the Types
table).