Put a subform control on your main form and set its source object
accordingly in the On Current event of the main form

Me!nameOfYourSubformControl = "NameOfAppropriateSubform"

Steve


"Tom" wrote in message
...
Working in Access 2007. I have a form that contains several tabbed
subforms.
I would like to only show one tab based on the data in a field on the main
part of the form...

Any thoughts. Not the sharpest pencil esp in 2007 but can follow
directions
fairly well...

Regards
Tom