My problem is getting the list box or list view to come up with those SchedIDs already pre-selected, as if someone had clicked the 3 rows in the list box. I don't know how an "IF" construct would help with that.
I tried it both with the variable having parenthesis around, and not having parenthesis around (when you multi-select, RBase does not put parenthesis around, so I'm guessing they aren't necessary) Karen -----Original Message----- From: Buddy Walker <[email protected]> To: [email protected] Sent: Tue, Sep 7, 2021 4:24 pm Subject: RE: [RBASE-L] - Pre-selected list view/box <!--#yiv8062045791 _filtered {} _filtered {}#yiv8062045791 #yiv8062045791 p.yiv8062045791MsoNormal, #yiv8062045791 li.yiv8062045791MsoNormal, #yiv8062045791 div.yiv8062045791MsoNormal {margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv8062045791 a:link, #yiv8062045791 span.yiv8062045791MsoHyperlink {color:blue;text-decoration:underline;}#yiv8062045791 span.yiv8062045791EmailStyle19 {font-family:"Calibri", sans-serif;color:windowtext;}#yiv8062045791 .yiv8062045791MsoChpDefault {font-family:"Calibri", sans-serif;} _filtered {}#yiv8062045791 div.yiv8062045791WordSection1 {}-->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]> Sent: Tuesday, September 7, 2021 4:05 PM To: [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: LstScheduleTypesSchedID (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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/448501553.2840480.1631045115484%40mail.yahoo.com.-- 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/002101d7a42e%24c71c71e0%24555555a0%24%40comcast.net. -- 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/439570168.2863363.1631050028118%40mail.yahoo.com.
