Updating records and List/menu

[Infopumper]

:mad: OK. I have been attempting to do this for some time:
Dynamic List/Menu
Dropdiwn with Usernames
Need to update Record Using the Dropdown
Using ASP, VB, And Dreamweaver

Form Code:

<form id="form1" name="form1" method="POST" action="<%=MM_e ditAction%>">
<p align="center">
<label>Update User<br />
<select name="slUser" id="slUser">
<%
While (NOT RSNames.EOF)
%>
<option value="<%=(RSNa mes.Fields.Item ("UserID").Valu e)%>"><%=(RSNam es.Fields.Item( "Name").Value)% ></option>
<%
RSNames.MoveNex t()
Wend
If (RSNames.Cursor Type > 0) Then
RSNames.MoveFir st
Else
RSNames.Requery
End If
%>
</select>
</label>
</p>
<p align="center">
<label>Defense< br />
<input name="txDef" type="text" id="txDef" size="15" />
</label>
</p>
<p align="center">
<input name="hiddenFie ld" type="hidden" value="<%=now%> " />
<label>
<input name="btUpdate" type="submit" id="btUpdate" value="Update" />
</label>
</p>
<input type="hidden" name="MM_update " value="form1">
<input type="hidden" name="MM_record Id" value="<%= RSUpdates.Field s.Item("PlayerI D").Value %>">
</form>

Form Will update 1st Record..
Update Record Set up as follows:
Connection/Updates/Record from All OK
IniqueKey-UserID
After Update-Blank
slUser- <ignore>
txDef Updates column "Ulev" (Numeric)
HiddenField Updates column "EditDate" (Date)

If I select slUser to update "UserID" Get error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot update identity column 'PlayerID'.

I have been wracking my Brain about this issue..
Thank you for your Time and assistance..

[sashi]

Hi there,

If I select slUser to update "UserID" Get error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot update identity column 'PlayerID'.

you cannot update a primary key.. primary keys are meant to be unique.. meaning you cannot have a duplicate record when the field in set to be primary key.. :)

[Infopumper]

I do understand that. What I am trying to do is:
Update a record using the selection from a List/Menu
I am not attempting to update the Primary key (Although I have tried).
I am trying to get away from needing to go to a second page to update a record.

Any help with this would be most appreciated.
Thank you in advance.