Problems with code when converting database to Access2000 from Access97
Try moving the .Bookmark statement after the Update method.
----
Quote:
> Can anybody tell me why this code doesn't work in Access2000 after I
> converted the database from Access97?
> When this code runs in Access2000, I get an "Update or Cancel Update
without
> AddNew or edit". It works just fine in Access97.
> Private Sub Command87_Click()
> On Error GoTo Err_Command87_Click
> Dim stDocName As String
> Dim db As Database
> Dim rstRFP As Recordset
> Set db = CurrentDb()
> Set rstRFP = db.OpenRecordset("HBERFP", DB_OPEN_DYNASET)
> With rstRFP
> .AddNew
> ![ClientID] = "MCKHBOC00"
> ![PROPCODE] = Me!PROPCODE
> .Bookmark = rstRFP.LastModified
> .Update
> End With
> Thanks for your help!
--
++++++++++++++++++++++++++++++++++++++++
Check it:
O.o. H.N.N. o.O.: http://hackernews.com
Sent via Deja.com http://www.deja.com/
Before you buy.
