Problem with Case Select Statement
Posted on 2006-10-26
I'm new to using Case statements and can't figure out why this one isn't working.
I've tried it a couple ways, but below is the way I think it should work. I want this statement to disable the Group Field and insert the value N/A if the field if the FuncIden = E and the TypeIden does not equal F. It doesn't work right.
The default value of Me.Group.Enabled is False. If someone selects E and anything else but F I want the Group to become enabled.
Is the way I wrote this correct?
Private Sub tblGEFSAdd_TypeIden_AfterUpdate()
Select Case False
Case Me.FuncIden.Value = "E" And Me.TypeIden.Value <> "F"
Me.Group.Value = "N/A"
Me.Group.Enabled = False
Me.TitlebyType.Enabled = True
Me.Group.Enabled = True