Code to combine report filter and date range

[rhubarb]

I was trying both as neither of them seem to work:



Currently:

Private Sub lstTicketReport_AfterUpdate()

If Me.lstTicketReport.Selected(1) = True Then
Me.txtStartDate.Enabled = True
Me.txtEndDate.Enabled = True

End If


InitFilterItems


End Sub

[rhubarb]

Finally, I was missing the Requery. Thank you for your patience and assistance!

Private Sub lstTicketReport_AfterUpdate()


Me.lstTicketReport.Requery

If Me.lstTicketReport.Selected(1) = True Then
Me.txtStartDate.Enabled = True
Me.txtEndDate.Enabled = True
Else
Me.txtStartDate.Enabled = False
Me.txtEndDate.Enabled = False
End If


InitFilterItems


End Sub

[June7]

Glad you figured it out. I have no idea why requery resolved the issue.