In your .cfg file remove the extra lines between your selects like this:
%db_select_fields = (
Day => 'Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,All of,N/A',
Month => 'January,February,March,April,May,June,July,August,September,October,November,December',
Datenum => '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,All',
Year => '2002,2003'
and add a comma at the end of the Datenum line.
Checkbox fields are yes/no fields, and not to be used for a list of selections. If you want to have choices you would either need to change what you have to radio fields, or to define each checkbox as a field. If you use JPDen's configurator it will help you to setup those fields if you don't want to do it manually. There is also information on using checkboxes in the FAQ noted below with examples.
Also please note that the -1 and -2 only work if you have autogenerate turned on. You can control the display and viewing of those fields within your page layouts.
You are missing a field in your html_record_form for the Userid. If you want this admin only but to have the script automatically add the userid, check the FAQ under the section "Admin" for a thread called "How can I get the userid to be displayed in the add form?"
There was a few problems in your html_record_form, the hidden fields were missing the Value=. I've made the changes and condensed the code below. Please note I added hidden fields within table tags, as they are being inserted within the table :)
You might also want to make your Userid field required.
<TABLE WIDTH="475" CELLPADDING=0 CELLSPACING=0 BORDER=1 BGCOLOR="#FFFFCC">
<TR><TD colspan=2><input type="hidden" NAME="ID" VALUE="$rec{'ID'}"></TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP" width="20%"> <$font>Name of Program:</FONT></TD>
<TD VALIGN="TOP"> <INPUT TYPE="TEXT" NAME="Name" VALUE="$rec{'Name'}" SIZE="40" MAXLENGTH="255" width="80%"></TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP"><$font>Type of Program:</FONT></TD>
<TD VALIGN="TOP"> |; print &build_checkbox_field ("Type", "$rec{'Type'}"); print qq|</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP"><$font>Age Group:</FONT></TD>
<TD VALIGN="TOP"> |; print &build_checkbox_field ("Age_Group", "$rec{'Age_Group'}"); print qq|</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP"><$font>Description:</FONT></TD>
<TD VALIGN="TOP"> <TEXTAREA NAME="Description" ROWS="5" COLS="40" WRAP="HARD" MAXLENGTH="1500">$rec{'Description'}</TEXTAREA></TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP"><$font>Branch:</FONT></TD>
<TD VALIGN="TOP"><$font> |; print &build_checkbox_field ("Branch", "$rec{'Branch'}"); print qq|</font></TD></TR>|;
if ($per_admin) { print qq|
<TR><TD ALIGN="Right" VALIGN="TOP"><$font>Day:</FONT></TD><TD VALIGN="TOP"> |; print &build_select_field ("Day", "$rec{'Day'}"); print qq|</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP"><$font>Date: </FONT></TD>
<TD VALIGN="TOP"> |; print &build_select_field ("Month", "$rec{'Month'}"); print qq| |; print &build_select_field ("Datenum", "$rec{'Datenum'}"); print qq| |; print &build_select_field ("Year", "$rec{'Year'}"); print qq|</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP"><$font>Time: </FONT></TD>
<TD VALIGN="TOP"> <INPUT TYPE="TEXT" NAME="Time" VALUE="$rec{'Time'}" SIZE="25" MAXLENGTH="255"></TD></TR>
<TR><TD><$font><B>User ID:</B></font> $reqpic</TD><TD><INPUT TYPE="TEXT" NAME="UserID" SIZE="10" VALUE="$rec{'UserID'}" MAXLENGTH="8"></TD></TR> |;
}
else {
print qq|<TR><TD colspan=2>
<input type="hidden" name="Day" VALUE="$rec{'Day'}">
<input type ="hidden" name="Month" VALUE="$rec{'Month'}">
<input type="hidden" name="Datenum" VALUE="$rec{'Datenum'}">
<input type="hidden" name="Year" VALUE="$rec{'Year'}">
<input type="hidden" name="Time" VALUE="$rec{'Time'}">
<input type="hidden" NAME="Userid" VALUE="$rec{'Userid'}">
</TD></TR> |;
}
print qq|</TABLE> |;
Hope this gets you up and running.
Unoffical DBMan FAQ
http://creativecomputingweb.com/dbman/index.shtml/