I don't need a WHERE clause. My list box is going to show all 10 rows of my lookup table (LstScheduleTypes). I want 3 of those rows to be pre-selected as if the user had just clicked them, based on my vST variable with the IDs of the 3 to be highlighted Have you ever had a list box or list view on a form with values pre-selected? That's what I'm trying to find out how to do
Karen -----Original Message----- From: Buddy Walker <[email protected]> To: [email protected] Sent: Tue, Sep 7, 2021 4:29 pm Subject: RE: [RBASE-L] - Pre-selected list view/box <!--#yiv7365791096 _filtered {} _filtered {}#yiv7365791096 #yiv7365791096 p.yiv7365791096MsoNormal, #yiv7365791096 li.yiv7365791096MsoNormal, #yiv7365791096 div.yiv7365791096MsoNormal {margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv7365791096 a:link, #yiv7365791096 span.yiv7365791096MsoHyperlink {color:blue;text-decoration:underline;}#yiv7365791096 span.yiv7365791096EmailStyle21 {font-family:"Calibri", sans-serif;color:windowtext;}#yiv7365791096 .yiv7365791096MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv7365791096 div.yiv7365791096WordSection1 {}-->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]> 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/002e01d7a42f%246181e580%242485b080%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/87737958.2873666.1631050288016%40mail.yahoo.com.
