How to make a field visible if other dependent field is completed?
I have 2 fields in a form:
1) A drop down list to describe call results sales reps make. One of the call results is: Call Again
2) Second field I have is: Call Again Date
I want to make "Call Again Date" field visible only when sales rep selects "Call Again" from the drop down list on field 1.
They select Call Again (field 1).
Call Again Date (field 2) becomes visible. So they can fill out the date a customer wants to be called back.
If sales rep selects any other option from the drop down list on field 1, then I don't want Call Again Date to be visible.
Try the following since me.call_results_id is a number and not a string.
Private Sub Call_Results_ID_AfterUpdate()
If Me.Call_Results_ID = 8 Then
Me.Call_Again_Date.Visible = True
Me.Call_Again_Date.Visible = False
Private Sub Combo8_AfterUpdate()
If Me.Combo8 = "Call Again" Then
Me.callagaindate.Visible = True
Me.callagaindate.Visible = False
This worked on a sample table I created. It won't work with the other table since there are more than one rows in that table depending on how many calls were made to that customer on different dates.
So if a sales rep calls a customer on 05/20/04 and the call result for that day might be "Left Message".
And when the sales reps calls the customer again on 05/22/04 and the call result is "Call Again", there'll be 2 result sets with different call result.
So I don't think this would work.