Conditionally Clear list Box

[#1]

Hi There

I have a basic year and month list boxes, i want to clear the month list box if there is no year selected, how can i do this ?

Thanx

[#2 · Accepted solution]

You can create a macro that will fire when there is a change to the Year field. On the Trigger tab under Document Properties, you want to add a macro for the OnChange of the Year field. I'd also set up a variable (vYear) with the formula:

=GetSelectedCount(Year)

For the macro, use something like:

If ActiveDocument.Variables("vYear").GetContent.String>0 Then
ActiveDocument.Fields("Month").Clear
End If

[#3]

Thanx NMiller and for the opther post as well 🙂