Hi,
I'm working on a Service Order Database, and I have a Combo Box named Status with entries (In progress, Complete, Pending, Cancelled) and there is an Event Procedure (After Update) for this combo Box that makes another Combo Box named Reason appear ONLY when i select Pending, then i have to specify why it is Pending from the Reason Combo Box.
The problem is when i go to the search form and status is Pending and i want to make the status Complete, the Combo Box is still showing, in other words i want to Reason Combo Box disapear when i make status like Inprogress, Complete, or Cancelled.
here is the Code i used in my Entry form
Private Sub Status_AfterUpdate()
If Me.Status = "pending" Then
Me.Reason.Visible = True
Else
Me.Reason.Visible = False
End If
End Sub
Please note that this codes works well with the Data Entry form but the problem is with the search form that is based on a query.
I do appreciate your help in this matter.
I'm working on a Service Order Database, and I have a Combo Box named Status with entries (In progress, Complete, Pending, Cancelled) and there is an Event Procedure (After Update) for this combo Box that makes another Combo Box named Reason appear ONLY when i select Pending, then i have to specify why it is Pending from the Reason Combo Box.
The problem is when i go to the search form and status is Pending and i want to make the status Complete, the Combo Box is still showing, in other words i want to Reason Combo Box disapear when i make status like Inprogress, Complete, or Cancelled.
here is the Code i used in my Entry form
Private Sub Status_AfterUpdate()
If Me.Status = "pending" Then
Me.Reason.Visible = True
Else
Me.Reason.Visible = False
End If
End Sub
Please note that this codes works well with the Data Entry form but the problem is with the search form that is based on a query.
I do appreciate your help in this matter.
