<img src=/S/frown.gif border=0 alt=frown width=15 height=15>
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