current record after .update 1

[kronar30]

When I use rec.Edit, update a field, then rec.Update
the record is updated, however current record always seems to be the next record in the table.
How do I keep this same record as the current record to do further updates to?
Findfirst after an update gets run time error??
I am using Access 97

 

[MazeWorX]

can you post your code ... sounds like you have a rs.MoveNext in your code

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[kronar30]

Set JBrec = db.OpenRecordset("JB_Jobs")
JBrec.AddNew
JBrec("JB_JobBidNo") = strBidNo
JBrec("JB_JobName") = "Addnew record"
JBrec.Update

JBrec.Edit
JBrec("JB_Specs") = strBidNo & " curr rec"
JBrec.Update

this is the code I used to test it. "curr rec" gets entered into the next record in the table instead of the same record I just updated??

 

[MazeWorX]

Set JBrec = db.OpenRecordset("JB_Jobs", dbOpenDynaset)

With JBrec
.AddNew
.Fields("JB_JobBidNo") = strBidNo
.Fields("JB_JobName") = "Addnew record"
.Fields("JB_Specs") = strBidNo & " curr rec"
.Update
End With

untested .. Thoughts

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[Axworthy]

When you add a record, that record does not automatically become the current record. Between the add and the edit, you should put in:

JBrec.Bookmark = JBrec.LastModified