Open a Form from a Combo box

[Atholl]

Hi all,

The title says it all; how can I make a form appear when something is selected from a combo box?

Thanks in advance,

Atholl

 

[dopedealer]

On the AfterUpdate Event of the ComboBox in question Code in VBA along the lines of:
Private Sub ComboSomeCombo_AfterUpdate()
If ComboSomeCombo.Value = "SomeValueinthelist" Then
DoCmd.OpenForm "frmSomeForm"
End If
End Sub
hth
Chris

 

[Atholl]

Cheers for that, works a charm

Atholl