Appending an Incremental Variable to a String in a Loop

[nbardach]

Hope this finds everyone well. Happy New Year!

I'm trying to build a Loop for a set of dropdown menus I'm inserting into a form.

Basically, the client has to be able to select 1 to 20 donors with the dropdown options (member names) pulled from the DB. When the client is editing a donation record, she needs to be able to view the correct donors for a specific donation record selected in the dropdowns. This means matching the Donor IDs in the Donations Table with the Member IDs in the Members table, and then pulling the member's name to display in the dropdown.

Unless I can find a way to loop, I've got to have 20 of these in my code

Below is what the non-incremental, non-loop dropdown looks like:

<div id="donor_1" style="display: inline">

<select name="Donor_ID_ 1">
<option value="">-- Select the Donor --</option>
<% DO UNTIL MembersInfo.EOF %>
<% strMembersID1 = MembersInfo.Fie lds("ID") %>
<% intComparison1 = strComp(strMemb ersID1, strRecord_ID_1) %>
<option <% IF intComparison1 = 0 THEN %>selected<% END IF %> value="<%=Membe rsInfo.Fields(" ID")%>"><%=Memb ersInfo.Fields( "L_Name")% >, <%=MembersInfo. Fields("F_Name" )%>&nbsp;<% IF MembersInfo.Fie lds("M_Init") <> "" THEN%><%=Member sInfo.Fields("M _Init")%><% END IF %> (User ID: <%=MembersInfo. Fields("ID")%>) </option>
<% MembersInfo.MOV ENEXT %>
<% LOOP %>
<% MembersInfo.MOV EFIRST %>
</select> &nbsp;<input type="button" value="+" name="add_donor _1" onClick="toggle Box('donor_2',1 );" title="Add an Additional Donor"><br>

</div>

Here's my attempt at a loop...but it's not working:

<%
x = 1
DO WHILE x < 21
%>
<div id="donor_<%=x% >" style="display: inline">

<select name="Donor_ID_ <%=x%>">
<option value="">-- Select the Donor --</option>
<% DO UNTIL MembersInfo.EOF %>
<% strMembersID+"& x&" = MembersInfo.Fie lds("ID") %>
<% intComparison+x = strComp(strMemb ersID+x, strRecord_ID_+x ) %>
<option <% IF intComparison+x = 0 THEN %>selected<% END IF %> value="<%=Membe rsInfo.Fields(" ID")%>"><%=Memb ersInfo.Fields( "L_Name")% >, <%=MembersInfo. Fields("F_Name" )%>&nbsp;<% IF MembersInfo.Fie lds("M_Init") <> "" THEN%><%=Member sInfo.Fields("M _Init")%><% END IF %> (User ID: <%=MembersInfo. Fields("ID")%>) </option>
<% MembersInfo.MOV ENEXT %>
<% LOOP %>
<% MembersInfo.MOV EFIRST %>
</select> &nbsp;<input type="button" value="+" name="add_donor _<%=x%>" onClick="toggle Box('donor_<%=x +1%>',1);" title="Add an Additional Donor"><br>

</div>
<% x = x+1 %>
<% LOOP %>

Any and all help would be greatly appreciated. I feel like I'm just blowing the syntax on appending the incremental integer to the other strings.

Many thanks in advance! Noah