Rick - I think some of the problem is when you reach the expression size limit in the variable, gtprodtype. Could you add:
UNION SELECT 'All Records" FROM somecontroltable or even do a preliminary select by some other sorting group so that the number of records is smaller? If not, then you'd have to set up a form with a scrolling region for them to mark each of the records they want. Sami ----------------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 mailto:[EMAIL PROTECTED] 913-915-1971 ----- Original Message ----- From: Trinity Business Technologies To: RBASE-L Mailing List Sent: Thursday, December 18, 2003 3:28 AM Subject: [RBASE-L] - CHKBOX Limitations, Problem #1. I am using R:Base v6.5++ (Windows) Build 1.866xRT03. I have created a utility that utilizes the CHOOSE command with the CHKBOX n parameter. I have a table in my database that contains 250 rows of data. One of the fields in my database is named "prodtype" and contains unique values but is not a Primary Key. The user is presented with a list of every value within the specified field and is asked to select the values they want to use from the list. Here is how I have constructed the CHOOSE command: CHOOSE gtprodtype FROM #VALUES FOR prodtype FROM products AT 25, 35 CHKBOX 500 TITLE 'Select Product Types' When the program is run the user presses SHFT-F6 to select all the values. A message is then displayed that tells the user that "Maximum Number Of Checks Has Been Made". When I check the contents of the gtprodtype variable it only contains 99 values, not 250. What do I need to do to allow the user to select all 250 values? Thanks for your assistance. RB
