ADO Recordset

[Guest]

I am trying to update a ADODB.Recordset from the After Update event procedure
of a form, I have the following code in the event:
Dim rs As New ADODB.Recordset
rs.Open "tbl",CurrentProject.Connection,adOpenStatic,adLockOptimistic
rs.Fields(0) = AssetNumber
rs.Fields(1) = fOSUserName()
rs.Fields(2) = Now()
rs.Update
rs.Close
I recieve the following error:
3021 Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record
Can anyone help with this ???

 

[Brendan Reynolds]

You're missing an rs.AddNew after the rs.Open.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Guest]

http://support.microsoft.com/default.aspx?scid=kb;EN-US%
3B246335

 

[Guest]

Thanks Brendan I found that just before you replyed and posted in the
question I asked yesterday about Update ADODB recordset thanks again Dave

 

[Guest]

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnacchbk/html/acsybex_chap6.asp