Open A Form (Access 97)

[RNCIENG]

<img src=/S/frown.gif border=0 alt=frown width=15 height=15>
Good Morning,

A new dilema....

I have a combo box:
AP, UNT, EIN, NC, ADD etc for the values.

In the AfterUpdate event I want to, depending on the selection of the user, open a form. If the user selects either "AP", "UNT" or "EIN", then I want a specific form, frmPhyChanges, to open, if the user selects NC then nothing should happen. I have the following code in the AfterUpdate event of cboLegend but I get a type mismatch error with the "If" line highlighted. Can someone please help me?

Dim strLeg As String
strLeg = txtBdLegend
If strLeg = "UN / T" Or "AP" Or "EIN" Then
DoCmd.OpenForm "frmPhyChanges", acNormal, "", "", , acNormal
End If

Thanks,

[Francois]

Use
If strLeg = "UN / T" Or strLeg = "AP" Or strLeg = "EIN" Then