No Current record error

[dhstein]

I am adding a new entry in a table with .AddNew followed by .Update
Further down in the program, I want to modify a field in that record. What
is the syntax to refer to that record?

I tried rsMytable.LastUpdated.Edit

Thanks for any help with this

 

[Dirk Goldgar]

I am adding a new entry in a table with .AddNew followed by .Update
Further down in the program, I want to modify a field in that record.
What
is the syntax to refer to that record?

I tried rsMytable.LastUpdated.Edit

Thanks for any help with this

The .LastModified property returns a bookmark, not a reference to the actual
record. Try this:

With rsMyTable
.Bookmark = .LastModified
.Edit
' ... set various field values ...
.Update
End With

 

[dhstein]

Thanks Dirk. Apparently it also works when I do :

rsMyrecordSet.LastUpdated

rsMyRecordSet.Edit

......
......
rsMyRecordSet.Update

 

[Dirk Goldgar]

Thanks Dirk. Apparently it also works when I do :

rsMyrecordSet.LastUpdated

rsMyRecordSet.Edit

.....
.....
rsMyRecordSet.Update

I don't see how that could possibly work! A recordset's LastUpdated
property is just the date/time the table or object was last mupdated.
Invoking it as though it were a method would have no effect on the
positioning of the recordset.

Maybe you meant "LastModified", not "LastUpdated". But that also would have
no effect on the position of the recordset. As I said, it simply returns a
bookmark that can be used to position the recordset by assigning it to the
recordset's Bookmark property.

You may *think* your recordset is being positioned by the code above, if it
happens that the recordset is already positioned at the record you wanted.
But normally that would not be the case.

 

[dhstein]

Dirk,

I'm sure you are correct. What I had done was delete all records in a
table and then create new records based on values in another table. So I did
an AddNew for the first record, but when I tried to modify it I got the error
"No current record" So by doing an rsMyTable.LastUpdated I set the pointer
to the last record I updated which was also the record I wanted. Thanks.

 

[Dirk Goldgar]

I'm sure you are correct. What I had done was delete all records in a
table and then create new records based on values in another table. So I
did
an AddNew for the first record, but when I tried to modify it I got the
error
"No current record" So by doing an rsMyTable.LastUpdated I set the
pointer
to the last record I updated

Except that you didn't. Without seeing your real code, I can't say what
caused your problem in the first place, nor how you changed things so as to
avoid that problem, but I assure you that executing "rsMyTable.LastUpdated"
would have no effect whatsoever on the recordset's position.

 

[dhstein]

Dirk,

My apologies. I went back to check the code. I see I did a .MoveLast
which for my purposes did the trick.

 

[Dirk Goldgar]

My apologies. I went back to check the code. I see I did a .MoveLast
which for my purposes did the trick.

Ah, that explains it. No apologies necessary.