I have a form I am using to filter and display reports. I've attached a stripped-down version to this post. If you open the database and open the Reports form and Select "Billable" or select "Ticket Number" then make selection from the "Filter tickets" combo box and click on "Preview" it will show the proper reports. If you close the reports and select any other selection but "Ticket Number" or "Billable" and Filter again and hit preview you receive this error: Value you entered isn't valid for this field.
It's as if it is expecting a number for some reason and I'm not sure why. If I close and re-open and select any other report it works fine. It's only if I select Billable or Ticket Number. It's as if the number gets cached in lstTicketFilter and calculates before I make another selection from the lstTicketReport. Any direction or help is appreciated!
Also is there any way to not have Billable (Yes/No) transform into a -1 or 0? It's a cosmetic annoyance. As is the blank in the Return to Filter Tickets combo box. Not sure how or if I can change or fix but may be easy and I'm missing.
Thank you!