YAYY!!
It's working now. Thanks a lot !!!!

K Dales Wrote:
I just replied to your previous post, will copy it he

Either you do not have a new record created when you are trying th
update,
or else Access is locking it from you, preventing the update.

Did you remember to call the AddNew method of the recordset? If not
you
have not yet created the space for the new record, so when you try t
update
you run into the EOF. This would give the error message you ar
seeing.

If this is the case, make sure your code does the following afte
opening
the recordset:
Recordset1.AddNew 'optional: add field list and value list here, or:
' you will need code here to initialize all the fields in the ne
record
Recordset1.Update
....

A couple other things:
- Be sure to Update before any MoveNext, otherwise you will move pas
the
end of the file.
- Make sure your recordset's LockType allows updating and is no
allowing
Access to lock the record or table on you, preventing any updates.
suggest
using adLockPessimistic to ensure you have full possession of tha
record
until you actually update it.

For all you ever wanted to know about ADO,
http://msdn.microsoft.com/library/de...dooverview.asp

HTH - K Dales



"silvest" wrote:


anyone has any ideas ?


--
silvest

------------------------------------------------------------------------
silvest's Profile
http://www.excelforum.com/member.php...o&userid=14662
View this thread
http://www.excelforum.com/showthread...hreadid=275742



--
silves
-----------------------------------------------------------------------
silvest's Profile: http://www.excelforum.com/member.php...fo&userid=1466
View this thread: http://www.excelforum.com/showthread.php?threadid=27574