Trigger select in list box depended on another list box

[sarahshong]

Hi, I'm trying to create a trigger that will select items in List Box 2 dependent on what I have selected in List Box 1

In List Box 1, I have dates 3/1/2020, 4/1/2020, 5/1/2020.

List Box 2 has dates 03/01/2019, 04/01/2019, 05/01/2019.

When I select 3/1/2020 I would like to select 03/01/2019 in List Box 2

I have tried setting the variable vDate = date(MakeDate(year([List Box 1])-1,month([List Box 1]),'01'),'MM/DD/YYYY')

I get the correct output when I use that in a text box

But when i try to use the variable in the Field Event Trigger for List Box 1 using List Box 2 as my Field, it doesn't work.

I've tried

='('&$(vDate)&')'  

='('&$(=vDate)&')'

=$(vDate)

[jochem_zw · Accepted solution]

I think you have to add quotes around the dates so add chr(39) to your variable (4x)

[sarahshong]

Hi,

Can you show me what you mean? Does the single quotes in my search string not qualify as quotes?

[sarahshong]

I played around with it and it worked. Thanks!