I am reading back the next available number back from a database, and using this to add a new user (record). On submission though the information is processed but an Object Required Error is returned.
<%
dim NextID
NextNum="select Max(ACS_ROLE_ID)+1 as MaxRoleId from jjwwp.ACS_ROLE"
set NextID = conn.Execute(NextNum)
%>
<form method="post" action="adminAddNewRole.asp" name="form1" onSubmit="return validate()">
<table border=0 cellspacing=2 cellpadding=4 style="font-size:x-small; font-family:verdana">
<tr><td align=right bgcolor="#669999"><font size="2" color="#FFFFFF"><b>WWP Acs Role Id:</b></font></td>
<td bgcolor="#DBEBEB">
<input Name="RoleId" Size = "30" MAXLENGTH="3" value="<%=NextID("MaxRoleId"
%>" readonly> </td>
</tr></form>
<%
dim NextID
NextNum="select Max(ACS_ROLE_ID)+1 as MaxRoleId from jjwwp.ACS_ROLE"
set NextID = conn.Execute(NextNum)
%>
<form method="post" action="adminAddNewRole.asp" name="form1" onSubmit="return validate()">
<table border=0 cellspacing=2 cellpadding=4 style="font-size:x-small; font-family:verdana">
<tr><td align=right bgcolor="#669999"><font size="2" color="#FFFFFF"><b>WWP Acs Role Id:</b></font></td>
<td bgcolor="#DBEBEB">
<input Name="RoleId" Size = "30" MAXLENGTH="3" value="<%=NextID("MaxRoleId"
</tr></form>