Choose from more than one form (1 Viewer)

[Tin Man]

I have several forms that are slightly different. I need to have one of the forms displayed dependent on the data in a field. Example: Three forms A, B and C. If the data in field X = old, then display form A and populate it. If data in field X = new, then display form B and populate it. I have a main form with Tabs. I am trying to display the form A,B or C on one of the Tabs and have it change with each record that is selected. Is this possible? Thanks. . .

 

[AccessUser]

Put a subform on the tab.

On the AfterUpdate event on field X do something like this:

If me.fieldX = old then
Me.SubformName.SourceObject = "formA"
elseif me.fieldX = new then
Me.SubformName.SourceObject = "formB"
else
Me.SubformName.SourceObject = "formC"
endif

Where Me.SubformName is the name you give your subform.
Hope that helps.