Subform trigger through a combo box selection

[wideasleep]

Hello Everyone,

I am looking for a way to trigger specific subforms to come up in a form through a combo box selection. For example purposes my selection in the combo box is CCP-03-081-FRM-14. The Subform is,"Area14".

I also have the combo box populating other fields in my form.

I am running Vista Home Premium with Access 2007.

Thanks for any info!

[Rabbit]

Hello Everyone,

I am looking for a way to trigger specific subforms to come up in a form through a combo box selection. For example purposes my selection in the combo box is CCP-03-081-FRM-14. The Subform is,"Area14".

I also have the combo box populating other fields in my form.

I am running Vista Home Premium with Access 2007.

Thanks for any info!

Use the after update event to change the subform control's SourceObject property.

[wideasleep]

Use the after update event to change the subform control's SourceObject property.

As the newbie that I am to doing this, can you give me an example of the code and if I use MACRO, EXPRESSION or CODE BUILDER.

Thanks for the input

[Rabbit]

I use 03 so I don't know how well this code will work in 07, plus I haven't tested it.

Private Sub Combobox1_AfterUpdate()
   Select Case Combobox1
      Case "Option1"
         Me.SubformName.SourceObject = "Form1"
      Case "Option2"
         Me.SubformName.SourceObject = "Form2"
   End Select
End Sub