Should be .vST not .vStat
You could also use that as a WHERE clause From: [email protected] <[email protected]> On Behalf Of Buddy Walker Sent: Tuesday, September 7, 2021 5:25 PM To: [email protected] Subject: RE: [RBASE-L] - Pre-selected list view/box Karen Compare the schedid to variable using IN. Variable would have to have () around the values and since they are integer you shouldn’t need quotes around each value SET VAR vST TEXT = (‘(‘ + .vST + ‘)’) IF SchedID IN .vStat THEN XXXXX ELSE YYYYY ENDIF Buddy From: 'Karen Tellef' via RBASE-L <[email protected] <mailto:[email protected]> > Sent: Tuesday, September 7, 2021 4:05 PM To: [email protected] <mailto:[email protected]> Subject: [RBASE-L] - Pre-selected list view/box I'm not sure I've tried this before, and I don't have any notes saved on how to do it. I want either a variable list view or list box on a form where multiple values are pre-selected. Anyone have code they can share to do this? In my situation, it's a tiny table: LstScheduleTypes SchedID (PK integer) ScheduleType I will have a list of the SchedIDs, such as 2, 4, 6 The list will show just the schedule types associated with those IDs I have tried having the list box variable pre-defined: vST TEXT = "2,4,6" vST is the variable associated with my list box, with SchedID as the Key Field, and ScheduleType showing as the list, but nothing is pre-selected Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/448501553.2840480.1631045115484%40mail.yahoo.com <https://groups.google.com/d/msgid/rbase-l/448501553.2840480.1631045115484%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/002101d7a42e%24c71c71e0%24555555a0%24%40comcast.net <https://groups.google.com/d/msgid/rbase-l/002101d7a42e%24c71c71e0%24555555a0%24%40comcast.net?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/002e01d7a42f%246181e580%242485b080%24%40comcast.net.
