Hi Cetin,

Thanks for responding.
If this helps any . . . I have 2 combo boxes with conditional choices in each, and the following code is in the click event of a command button on the form.


public gdValue
gdValue = Thisform.gd1.displayvalue

public szValue
szValue = Thisform.sz1.displayvalue

SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen12;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen22;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen32;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen42;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen52;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen62;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen72;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen82;

acBundle2 = bunlen12+bunlen22+bunlen32+bunlen42+bunlen52+bunlen62+bunlen72+bunlen82



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen14;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen24;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen34;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen44;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen54;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen64;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen74;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen84;

acBundle4 = bunlen14+bunlen24+bunlen34+bunlen44+bunlen54+bunlen64+bunlen74+bunlen84



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen16;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen26;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen36;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen46;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen56;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen66;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen76;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen86;

acBundle6 = bunlen16+bunlen26+bunlen36+bunlen46+bunlen56+bunlen66+bunlen76+bunlen86



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen17;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen27;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen37;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen47;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen57;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen67;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen77;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen87;

acBundle7 = bunlen17+bunlen27+bunlen37+bunlen47+bunlen57+bunlen67+bunlen77+bunlen87



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen18;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen28;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen38;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen48;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen58;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen68;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen78;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen88;

acBundle8 = bunlen18+bunlen28+bunlen38+bunlen48+bunlen58+bunlen68+bunlen78+bunlen88



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen110;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen210;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen310;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen410;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen510;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen610;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen710;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen810;

acBundle10 = bunlen110+bunlen210+bunlen310+bunlen410+bunlen510+bunlen610+bunlen710+bunlen810



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen112;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen212;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen312;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen412;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen512;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen612;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen712;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen812;

acBundle12 = bunlen112+bunlen212+bunlen312+bunlen412+bunlen512+bunlen612+bunlen712+bunlen812



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen114;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen214;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen314;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen414;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen514;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen614;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen714;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen814;

acBundle14 = bunlen114+bunlen214+bunlen314+bunlen414+bunlen514+bunlen614+bunlen714+bunlen814



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen116;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen216;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen316;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen416;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen516;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen616;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen716;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen816;

acBundle16 = bunlen116+bunlen216+bunlen316+bunlen416+bunlen516+bunlen616+bunlen716+bunlen816



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen118;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen218;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen318;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen418;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen518;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen618;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen718;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen818;

acBundle18 = bunlen118+bunlen218+bunlen318+bunlen418+bunlen518+bunlen618+bunlen718+bunlen818



SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen120;

SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen220;

SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen320;

SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen420;

SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen520;

SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen620;

SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen720;

SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen820;


acBundle20 = bunlen120+bunlen220+bunlen320+bunlen420+bunlen520+bunlen620+bunlen720+bunlen820


REPORT FORM siz_grade.FRX preview



*THIS REPORT HAS FIELDS ACBUNDLE2, ACBUNDLE4, ACBUNDLE6, ACBUNDLE7.......