Hi Murray - The form code is below. I simply want to insert a
new record
into Access. I've removed the dynamic radio button code
<form ACTION="<%=MM_editAction%>" METHOD="POST"
id="form1" name="form1">
<table width="100%" border="0" cellpadding="0"
cellspacing="5"
class="maintxt">
<tr>
<td width="59"> </td>
<td width="332" valign="middle"
bgcolor="#292929"><div
align="right">
<input name="InstID" type="hidden" id="InstID"
value="<%=(RSinstrument.Fields.Item("InstrumentID").Value)%>"
/>
Date : </div></td>
<td width="458" valign="middle"
bgcolor="#292929"><label>
<input name="historydate" type="text"
class="registering_txtbox" id="historydate" size="30" />
</label></td>
<td width="62"> </td>
</tr>
<tr>
<td> </td>
<td valign="middle" bgcolor="#292929"><div
align="right">Formal
calibration certificate : </div></td>
<td valign="middle" bgcolor="#292929"><label>
<input name="formal_cal" type="radio"
class="registering_txtbox" value="-1" />
YES </label>
<label>
<input name="formal_cal" type="radio"
class="registering_txtbox" value="0" />
NO </label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td valign="middle" bgcolor="#292929"><div
align="right">Check
against designated reference circuit/device
</div></td>
<td valign="middle" bgcolor="#292929"><label>
<input name="check_against" type="radio"
class="registering_txtbox" value="-1" />
YES
</label>
<label>
<input name="check_against" type="radio"
class="registering_txtbox" value="0" />
NO </label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td valign="middle" bgcolor="#292929"><div
align="right">Cross-check against another test instrument
: </div></td>
<td valign="middle" bgcolor="#292929"><label>
<input name="cross_check" type="radio"
class="registering_txtbox" value="-1" />
YES
</label>
<label>
<input name="cross_check" type="radio"
class="registering_txtbox" value="0" />
NO </label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td valign="middle" bgcolor="#292929"><div
align="right">Identity of other test instrument :
</div></td>
<td valign="middle" bgcolor="#292929"><label>
<input name="identity" type="text"
class="registering_txtbox"
id="identity" size="40" />
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td valign="middle" bgcolor="#292929"><div
align="right">Repair
: </div></td>
<td valign="middle" bgcolor="#292929"><label>
<input name="repaired" type="radio"
class="registering_txtbox"
value="-1" />
YES
</label>
<label>
<input name="repaired" type="radio"
class="registering_txtbox"
value="0" />
NO </label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td valign="top" bgcolor="#292929"><div
align="right">Remarks :
</div></td>
<td valign="top" bgcolor="#292929"><label>
<textarea name="remarks" cols="40" rows="5"
class="registering_txtbox" id="remarks"></textarea>
</label></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td valign="top"
bgcolor="#292929"> </td>
<td valign="top" bgcolor="#292929"><label>
<input name="Submit" type="submit"
class="registering_txtbox"
value="Click to add history" />
</label></td>
<td> </td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote
in message
news:ftg3p6$3mv$1@forums.macromedia.com...
> Your code? Let's see it....
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
>
http://www.projectseven.com/go
- DW FAQs, Tutorials & Resources
>
http://www.dwfaq.com - DW FAQs,
Tutorials & Resources
> ==================
>
>
> "Andy" <andy@work.com> wrote in message
> news:ftg3gr$3bu$1@forums.macromedia.com...
>> My form has several sets of radio buttons to allow a
yes or now answer.
>> I need these values entered into my Access Database.
>> I've set the buttons using the 'server behaviour -
dynamic elements -
>> dynamic radio buttons'.
>> I've used averysetting i can think of but when i
sumit my form, all radio
>> button values are entered into Access as 'checked'
>> Any idea why??
>>
>> Thanks in advance
>> Andy
>>
>
2
Replies
AdChoices