Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi,
Can you show me what you mean? Does the single quotes in my search string not qualify as quotes?
I played around with it and it worked. Thanks!