Returning the values to the page is easy... what I would like to do is create a new record for each value that is selected.<BR><BR>Example: I&#039m creating a member record where one member may have multiple affiliations (say NSA, UNCLE, SMUSH). The new memberID generated from creating the record is returned as a variable (intMemberID). NSA, UNCLE, and SMUSH each have a value in the table (AffiliationsID) and share the variable (frmAffiliations).<BR>How can I create a loop sequence that will iterate through each of the selected affiliations and insert both the intMemberID and each selected affiliation? What would the SQLstmt look like?<BR><BR>Here&#039s the SQL statement that will successfully add the first<BR>selected Affiliation value.<BR>Sqlstmt6 = "INSERT INTO Member_Affiliation(MemberID,AffiliationsID) VALUES (&#039" & intMemberID & "&#039, &#039" & frmAffiliations & "&#039)"