>I'm not using cursors use recordset and assign the values from each object in the form
Are you using ADO recordset? It may use cursors behind the scenes. You need to run SQL Server Profiler to see what exactly is running.
If it's not broken, fix it until it is.
My Blog