Once last question, say I'm changing it from "billed wrong amount" to "never received bill" and so the billed amount field goes away. Is it possible to include code which clears out the billed amount field as well?
Try adding this:
Code:
Private Sub ComboComplaint_AfterUpdate()
If Complaint = "Didn't Receive Bill" Then
BillAmount = 0
End If
Call Form_Current
End Sub
Private Sub Form_Current()
If Complaint = "Billed wrong amount" Then
BillAmount.Visible = True
Else
BillAmount.Visible = False
End If
End Sub