passing dynamic form variables vi checkbox

Hi all

I'm trying to do what should be fairly simple, but I can't figure it out!

On page 1 I have a list of clubs and want to select some from a list via a
checkbox. The selected clubs will then be displayed on page 2, where I can
send an email to them.

Page one has the following form:
--------------
<form action="emailclubform.asp" method="post" enctype="multipart/form-data"
name="form1" id="form1">
<%
While ((Repeat1__numRows <> 0) AND (NOT rsClubs.EOF))
%>

<input type="checkbox" name="ClubID" value="1"
id="<%=(rsClubs.Fields.Item("ClubID").Value)%>"/>
<label for="checkbox">
<%=(rsClubs.Fields.Item("ClubName").Value)%></label>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsClubs.MoveNext()
Wend
%>
<br />
<label for="Submit"></label>
<input type="submit" name="Submit" value="Submit" id="Submit" />

</form>
---------------
This displays all the clubs and the checkboxes.

Page 2 has the following recordset (which is where I think I'm going wrong)
SELECT ClubID, ClubName, ClubEmail
FROM rotuki.Clubs
WHERE ClubID = request.Form ("ClubID")

The values from page 1 (the ClubID's) aren't passed to Page 2. I have tried
putting the ClubID as the value in the form, but that also fails.

Any help much appreciated - and if there's a better way of doing it, please
let me know.

Thanks
Chris