This is the error:<BR><BR>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.<BR><BR>Here's the code:<BR><BR> rsSecurityInfo.AddNew<BR> rsSecurityInfo("UserName") = strUserName<BR> rsSecurityInfo("Password") = strPassword<BR> rsSecurityInfo.Update<BR> <BR> rsPersonalInfo.AddNew<BR> rsPersonalInfo("PersonalID") = rsSecurityInfo("PersonalID") 'the problem is here, but I don't know why<BR> rsPersonalInfo("FName") = strFName<BR> rsPersonalInfo("LName") = strLName<BR> ...<BR> rsPersonalInfo.update<BR><BR>The PersonalID field is set as Identity (int) in rsSecurityInfo. The IDs in the rsSecurityInfo table are there, but it won't pull it to the rsPersonalInfo table. Does anyone see why? I see other examples like this that work fine, I don't know what I'm doing wrong. It acts like its trying to pass a null value. I'm using SQL 7.