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]

On Mon, 14 Jul 2003 21:12:55 -0400, "Deuce Sapp"
<deuce@perceive.nospamnet> wrote:

>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).

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]