On my form I have an option box for Band Option and a field box for Band Amount. When I click the Band Option box I want it to fill in the Band Amount field for 500. But it will not work and I cannot figure out why. Here is the code I am using, my option is True/False.
Private Sub Band_Option_AfterUpdate()
If (Me!Band_Option) = ["True"] Then
Me!Band_Price = "500"
Else
If (Me!Band_Option) = ["False"] Then
Me!Band_Price = "0"
End If
End Sub