drew22299 — Mon, 02 Jul 2007 12:08:01 +0000

Yes thanks that worked!

JeevesBond — Thu, 28 Jun 2007 12:40:20 +0000

You need to do a check to ensure you're not at BOF or EOF. I think it runs something like:

If Recordset.BOF Or Recordset.EOF Then 
  ... some error condition stuff
End If

'
I presume you're running a query to find the record that needs to be updated? It seems that query is not returning any records. You should also use Recordset.MoveFirst before trying to manipulate the current record.

Hope this helps.