s therReset Variables When Making ListBox Selection

[rebelfox]

I have a list box selection on calendar year for my report of purchase orders.

I have another list box selection on calendar month.

I also have an input box for a from date and another for a to date.  The input boxes use Document triggers to add selections against the variables assigned to the input boxes.

The year, month and input boxes work as cumulative selections with one problem.

When 'Clear' is clicked the variables on the input boxes are not cleared out.   the selection is removed but the variables retain their value on the report.  How can I reset these variables when the selection is removed as a report clear or as a cancel of the date selections from the 'current selections'?  Example below shows no selection from the input boxes after a 'clear' of selections but the input boxes still have a value.

[rebelfox · Accepted solution]

OK bit of a poorly explained problem and I have now solved it.

I merely needed to add more document trigger events against the date field.

If it changed I set it to the Min() and max() of the possible field values from my table.