I'm some problems with the SQL code for my update page.

I want to create a new type of update page. When a user updates a record rather than updating the record, I want a new record to be created with the 'DocVer' field (This is not an autonumber. I have a field called DocNo with that in it.)updated by one.

Any ideas what my SQL should be?

Thanks!

Neil