How do you reset the form when you go to a new record or just change a record?
I have this in VBA:
Private Sub Form_Load()
Me.O6Vote.Enabled = False
Me.GOVote.Enabled = False
Me.FinalVote.Enabled = False
Private Sub AOVote_BeforeUpdate(Cancel As Integer)
Me.O6Vote.Enabled = Not IsNull(AOVote) And Me.Level <> "Level 1"
Me.O6Vote.Enabled = Me.Level <> "Level 1" Or Me.Level = "Software" And Me.[Soft Level] <> "Level 1"
Me.FinalVote.Enabled = Not IsNull(AOVote) And Me.Level = "Level 1" Or Me.Level = "Software" And Me.[Soft Level] = "Level 1"
End Sub
Private Sub O6Vote_BeforeUpdate(Cancel As Integer)
Me.GOVote.Enabled = Not IsNull(O6Vote) And Me.Level = "Level 3 Cat 2" Or Me.Level = "Software" And Me.[Soft Level] = "Level 3 Cat 2"
Me.FinalVote.Enabled = Not IsNull(O6Vote) And (Me.Level = "Level 2") Or (Me.Level = "Software" And Me.[Soft Level] = "Level 2") Or Me.FinalVote.Enabled = Not IsNull(O6Vote) And (Me.Level = "Level 3 Cat 1") Or (Me.Level = "Software" And Me.[Soft Level] = "Level 3 Cat 1")
End Sub
Private Sub GOVote_BeforeUpdate(Cancel As Integer)
Me.FinalVote.Enabled = Not IsNull(GOVote) And Me.Level = "Level 3 Cat 2" Or Me.Level = "Software" And Me.[Soft Level] = "Level 3 Cat 2"
End Sub
Everything works fine until I go to the next/previous or new record. All the fields I wanted disabled have become enabled.