When I open a record in an HTML view it displays all records instead of a single record

When I open a record in an HTML view it displays all records instead of a single record


I have tried to follow the various tutirials on this forum, but i am stuck.

I have created a function that put a button on the list view of one of my form's data, that should open a single record, but when i click it it Opens all the records in the HTML view , instead of a single record... I have posted my code below, can someone PLEASE HELP.


Thank you in advanced.

    1. htmlpage Compost_HTML_View(ID)
    2. displayname = "Compost HTML View"
    3. print = true
    4. content
    5. <%{%>
    6. <%for each x in Compost_Tracker
    7.     {%>
    8. <div id="wrap">
    9.   <div id="header">
    10.     <h2>Compost Tracker Results</h2>
    11.     <h3>Date of Report: <%=x.Added_Time%> </h3>
    12.     <table width="100%" border="0" bordercolor="#000000" cellspacing="0" cellpadding="0" style="border-top:1px solid #000">
    13.       <tr>
    14.         <td width="33%" align="left">Phase I Batch #: <%=x.Phase_I_Batch%>,  <%=x.Phase_I_Batch_2%>,  <%=x.Phase_I_Batch_3%></td>
    15.         <td width="33%" align="left">Phase II Batch #: <%=x.Phase_II_Batch%> </td>
    16.         <td width="33%" align="left">Phase II Pull Date:  <%=x.Phase_II_Pull_Date%></td>
    17.       </tr>
    18.     </table>
    19.   </div>
    20.   <div id="phase_1">
    21.     <table width="100%" border="0" style="border:1px solid #000" cellspacing="0" cellpadding="0">
    22.       <tr>
    23.         <td width="70%" class="section_header" style="border:0px;"><h2 class="section_header">Phase I Section</h2></td>
    24.         <td width="30%" align="right" class="person_taking_report" style="border:0px; font-weight:bold; font-family:arial">Person Completing Section: <%=x.Person_Completing_Section%></td>
    25.       </tr>
    26.     </table>
    27.     <table width="100%" border="0" cellspacing="0" cellpadding="0">
    28.       <tr>
    29.         <td class="field"> Phase I Batch #  </td>
    30.         <td><%=x.Phase_I_Batch%>,  <%=x.Phase_I_Batch_2%>,  <%=x.Phase_I_Batch_3%>;</td>
    31.       </tr>
    32.       <tr>
    33.         <td class="field"> Phase I Moisture </td>
    34.         <td><%=x.Phase_I_Moisture%></td>
    35.       </tr>
    36.       <tr>
    37.         <td class="field"> Yards Per Foot </td>
    38.         <td><%=x.Yards_Per_Foot%></td>
    39.       </tr>
    40.       <tr>
    41.         <td class="field"> Fill Depth </td>
    42.         <td><%=x.Fill_Depth%></td>
    43.       </tr>
    44.       <tr>
    45.         <td class="field"> Compost Cure Details </td>
    46.         <td><%=x.Compost_Cure_Details%></td>
    47.       </tr>
    48.       <tr>
    49.         <td class="field"> Phase I Compost Comments </td>
    50.         <td><%=x.Phase_1_Compost_Comments%></td>
    51.       </tr>
    52.     </table>
    53.   </div>
    54.   
    55.      <div id="phase_2">
    56.     <table width="100%" border="0" style="border:1px solid #000" cellspacing="0" cellpadding="0">
    57.       <tr>
    58.         <td width="70%" class="section_header" style="border:0px;"><h2 class="section_header">Phase II Section</h2></td>
    59.         <td width="30%" align="right" class="person_taking_report" style="border:0px; font-weight:bold; font-family:arial">Person Completing Section: <%=x.Person_Completing_Section1%></td>
    60.       </tr>
    61.     </table>
    62.     <table width="100%" border="0" cellspacing="0" cellpadding="0">
    63.       <tr>
    64.         <td class="field"> Phase II Batch #:</td>
    65.         <td><%=x.Phase_II_Batch%></td>
    66.       </tr>
    67.       <tr>
    68.         <td class="field"> Phase II Pull Date:</td>
    69.         <td><%=x.Phase_II_Moisture1%></td>
    70.       </tr>
    71.       <tr>
    72.         <td class="field"> Phase II Tunnel Number:</td>
    73.         <td><%=x.Phase_II_Tunnel_Number%></td>
    74.       </tr>
    75.       <tr>
    76.         <td class="field"> Phase II Moisture:</td>
    77.         <td><%=x.Phase_II_Moisture1%></td>
    78.       </tr>
    79.       <tr>
    80.         <td class="field"> Type of Supplement: </td>
    81.         <td><%=x.Type_of_Supplement%></td>
    82.       </tr>
    83.       <tr>
    84.         <td class="field"> Rate of Supplement: </td>
    85.         <td><%=x.Rate_of_Supplement%></td>
    86.       </tr>
    87.             <tr>
    88.         <td class="field"> Spawn Type: </td>
    89.         <td><%=x.Spawn_Type%></td>
    90.       </tr>
    91.       <tr>
    92.         <td class="field"> Black Areas: </td>
    93.         <td><%=x.Black_Areas_PhaseII%></td>
    94.       </tr>
    95.             <tr>
    96.         <td class="field"> Water Added: </td>
    97.         <td><%=x.Water_Added_PhaseII%></td>
    98.       </tr>
    99.       <tr>
    100.         <td class="field"> Fire Fang: </td>
    101.         <td><%=x.Fire_Fang1%></td>
    102.       </tr>
    103.             <tr>
    104.         <td class="field"> Dry Layer on Floor: </td>
    105.         <td><%=x.Dry_Layer_on_Floor1%></td>
    106.       </tr>
    107.       <tr>
    108.         <td class="field"> Compost Cure Details: </td>
    109.         <td><%=x.Compost_Cure_Details1%></td>
    110.       </tr>
    111.             <tr>
    112.         <td class="field" height="75" valign="middle"> Phase II Comments on Phase I Compost: </td>
    113.         <td><%=x.Phase_II_Comments_on_Phase_I_Compost%></td>
    114.       </tr>
    115.       <tr>
    116.      <td class="field" height="75" valign="middle"> Phase II Comments for Phase II Compost: </td>
    117.         <td><%=x.Phase_II_Comments_for_Phase_I%></td>
    118.       </tr>
    119.       
    120.     </table>
    121.   </div>
    122.   
    123.   <div id="kennett">
    124.     <table width="100%" border="0" style="border:1px solid #000" cellspacing="0" cellpadding="0">
    125.       <tr>
    126.         <td width="70%" class="section_header" style="border:0px;"><h2 class="section_header">Kennett Farm Section</h2></td>
    127.         <td width="30%" align="right" class="person_taking_report" style="border:0px; font-weight:bold; font-family:arial">Person Completing Section: <%=x.Person_Completing_Section3%></td>
    128.       </tr>
    129.     </table>
    130.      <table width="100%" border="0" cellspacing="0" cellpadding="0">
    131.       <tr>
    132.         <td class="field"> Fill Date </td>
    133.         <td><%=x.Fill_Date%></td>
    134.       </tr>
    135.       <tr>
    136.         <td class="field"> House Number </td>
    137.         <td><%=x.House_Number%></td>
    138.       </tr>
    139.       <tr>
    140.         <td class="field"> Age of Compost </td>
    141.         <td><%=x.Age_of_compost%></td>
    142.       </tr>
    143.       <tr>
    144.         <td class="field"> Target Dry Weight </td>
    145.         <td><%=x.Target_Dry_Weight%></td>
    146.       </tr>
    147.       <tr>
    148.         <td class="field"> Actual Dry Weight </td>
    149.        <td><%=x.Actual_Dry_Weight%></td>
    150.       </tr>
    151.       <tr>
    152.         <td class="field"> # of Days in Incubation </td>
    153.         <td><%=x.of_days_in_Incubation%></td>
    154.       </tr>
    155.             <tr>
    156.         <td class="field"> % Colonization </td>
    157.         <td><%=x.Colonization%></td>
    158.       </tr>
    159.       <tr>
    160.         <td class="field"> Condition when filled </td>
    161.         <td><%=x.Condition_when_filled%></td>
    162.       </tr>
    163.       <tr>
    164.         <td class="field"> Molds Present During Spawn Run </td>
    165.         <td><%=x.Molds_Present_During_Spawn_Run%></td>
    166.       </tr>
    167.             <tr>
    168.         <td class="field"> Compost Cure Details </td>
    169.         <td><%=x.Compost_Cure_Details3%></td>
    170.       </tr>
    171.       <tr>
    172.         <td class="field" height="75" valign="middle"> Other Observations </td>
    173.         <td><%=x.Other_Observations3%></td>
    174.       </tr>
    175.     </table>
    176.   </div>
    177.   
    178.     <div id="alpine">
    179.     <table width="100%" border="0" style="border:1px solid #000" cellspacing="0" cellpadding="0">
    180.       <tr>
    181.         <td width="70%" class="section_header" style="border:0px;"><h2 class="section_header">Alpine Farm Section</h2></td>
    182.         <td width="30%" align="right" class="person_taking_report" style="border:0px; font-weight:bold; font-family:arial">Person Completing Section: <%=x.Person_Completing_Section4%></td>
    183.       </tr>
    184.     </table>
    185.     <table width="100%" border="0" cellspacing="0" cellpadding="0">
    186.       <tr>
    187.         <td class="field"> Fill Date </td>
    188.         <td><%=x.Fill_Date1%></td>
    189.       </tr>
    190.       <tr>
    191.         <td class="field"> House Number </td>
    192.        <td><%=x.House_Number1%></td>
    193.       </tr>
    194.       <tr>
    195.         <td class="field"> Age of Compost </td>
    196.         <td><%=x.Age_of_Compost1%></td>
    197.       </tr>
    198.       <tr>
    199.         <td class="field"> Target Dry Weight </td>
    200.         <td><%=x.Target_Dry_Weight1%></td>
    201.       </tr>
    202.       <tr>
    203.         <td class="field"> Actual Dry Weight </td>
    204.         <td><%=x.Actual_Dry_Weight1%></td>
    205.       </tr>
    206.       <tr>
    207.         <td class="field"> # of Days in Incubation </td>
    208.        <td><%=x.of_Days_in_Incubation1%></td>
    209.       </tr>
    210.             <tr>
    211.         <td class="field"> % Colonization </td>
    212.         <td><%=x.Colonization1%></td>
    213.       </tr>
    214.       <tr>
    215.         <td class="field"> Condition when filled </td>
    216.         <td><%=x.Condition_when_filled1%></td>
    217.       </tr>
    218.       <tr>
    219.         <td class="field"> Molds Present During Spawn Run </td>
    220.         <td><%=x.Molds_Present_During_Spawn_Run1%></td>
    221.       </tr>
    222.             <tr>
    223.         <td class="field"> Compost Cure Details </td>
    224.         <td><%=x.Compost_Cure_Details4%></td>
    225.       </tr>
    226.       <tr>
    227.         <td class="field" height="75" valign="middle"> Other Observations </td>
    228.         <td><%=x.Other_Observations%></td>
    229.       </tr>
    230.     </table>
    231.   </div>
    232.     <div id="westgrove">
    233.     <table width="100%" border="0" style="border:1px solid #000" cellspacing="0" cellpadding="0">
    234.       <tr>
    235.         <td width="70%" class="section_header" style="border:0px;"><h2 class="section_header">West Grove Section</h2></td>
    236.         <td width="30%" align="right" class="person_taking_report" style="border:0px; font-weight:bold; font-family:arial">Person Completing Section: <%=x.Person_Completing_Section5%> </td>
    237.       </tr>
    238.     </table>
    239.     <table width="100%" border="0" cellspacing="0" cellpadding="0">
    240.       <tr>
    241.         <td class="field"> Fill Date </td>
    242.         <td><%=x.Fill_Date2%></td>
    243.       </tr>
    244.       <tr>
    245.         <td class="field"> House Number </td>
    246.         <td><%=x.House_Number2%></td>
    247.       </tr>
    248.       <tr>
    249.         <td class="field"> Age of Compost </td>
    250.         <td><%=x.Age_of_Compost2%></td>
    251.       </tr>
    252.       <tr>
    253.         <td class="field"> Target Dry Weight </td>
    254.         <td><%=x.Target_Dry_Weight2%></td>
    255.       </tr>
    256.       <tr>
    257.         <td class="field"> Actual Dry Weight </td>
    258.         <td><%=x.Actual_Dry_Weight2%></td>
    259.       </tr>
    260.       <tr>
    261.         <td class="field"> # of Days in Incubation </td>
    262.         <td><%=x.of_Days_in_Incubation2%></td>
    263.       </tr>
    264.             <tr>
    265.         <td class="field"> % Colonization </td>
    266.         <td><%=x.Colonization2%></td>
    267.       </tr>
    268.       <tr>
    269.         <td class="field"> Condition when filled </td>
    270.         <td><%=x.Condition_when_filled2%></td>
    271.       </tr>
    272.       <tr>
    273.         <td class="field"> Molds Present During Spawn Run </td>
    274.         <td><%=x.Molds_Present_During_Spawn_Run2%></td>
    275.       </tr>
    276.             <tr>
    277.         <td class="field"> Compost Cure Details </td>
    278.         <td><%=x.Compost_Cure_Details5%></td>
    279.       </tr>
    280.       <tr>
    281.         <td class="field" height="75" valign="middle"> Other Observations </td>
    282.         <td><%=x.Other_Observations1%></td>
    283.       </tr>
    284.     </table>
    285.   </div>
    286.   
    287.     <div id="mj">
    288.     <table width="100%" border="0" style="border:1px solid #000" cellspacing="0" cellpadding="0">
    289.       <tr>
    290.         <td width="70%" class="section_header" style="border:0px;"><h2 class="section_header">M&J Farm Section</h2></td>
    291.         <td width="30%" align="right" class="person_taking_report" style="border:0px; font-weight:bold; font-family:arial">Person Completing Section: <%=x.Person_Completing_Section2%></td>
    292.       </tr>
    293.     </table>
    294.    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    295.       <tr>
    296.         <td class="field"> Fill Date </td>
    297.         <td><%=x.Fill_Date3%></td>
    298.       </tr>
    299.       <tr>
    300.         <td class="field"> House Number </td>
    301.         <td><%=x.House_Number3%></td>
    302.       </tr>
    303.       <tr>
    304.         <td class="field"> Age of Compost </td>
    305.         <td><%=x.Age_of_Compost3%></td>
    306.       </tr>
    307.       <tr>
    308.         <td class="field"> Target Dry Weight </td>
    309.        <td><%=x.Target_Dry_Weight3%></td>
    310.       </tr>
    311.       <tr>
    312.         <td class="field"> Actual Dry Weight </td>
    313.         <td><%=x.Actual_Dry_Weight3%></td>
    314.       </tr>
    315.       <tr>
    316.         <td class="field"> # of Days in Incubation </td>
    317.        <td><%=x.of_Days_in_Incubation3%></td>
    318.       </tr>
    319.             <tr>
    320.         <td class="field"> % Colonization </td>
    321.         <td><%=x.Colonization3%></td>
    322.       </tr>
    323.       <tr>
    324.         <td class="field"> Condition when filled </td>
    325.         <td><%=x.Condition_when_filled3%></td>
    326.       </tr>
    327.       <tr>
    328.         <td class="field"> Molds Present During Spawn Run </td>
    329.        <td><%=x.Molds_Present_During_Spawn_Run3%></td>
    330.       </tr>
    331.             <tr>
    332.         <td class="field"> Compost Cure Details </td>
    333.         <td><%=x.Compost_Cure_Details2%></td>
    334.       </tr>
    335.       <tr>
    336.         <td class="field" height="75" valign="middle"> Other Observations </td>
    337.         <td><%=x.Other_Observations2%></td>
    338.       </tr>
    339.     </table>
    340.   </div>
    341. </div>
    342. <br><br>                                                                                                                <%}
    343. }%>