Trevor Best <no****@besty.org.uk> wrote in
news:42**********************@news.zen.co.uk:
David W. Fenton wrote:
You might have run into the "feature" where you have more than
one recordset variable set to .RecordsetClone, move one and it
moves the other.
Er, wouldn't that be the case in A97, too?
I haven't used that for about 6 years. :-)
Well, that was the subject of discussion, i.e., things that work in
A97 and can break when converted to A2K.
And, given the concept of what .RecordsetClone is supposed to be
*for*, isn't that the way you'd *want* it to work?
<fx: long sigh> That's why I mentioned it. It's more likely that
it's
that what happened to Steve than what he said (moving
recordsetclone moved the form as well, see below, that requires a
bit more effort)
I still don't get what the complaint is. It does what it's supposed
to do. It did it that way in A97, it appears to me to do the same
things in A2K.
Steve's problems appear to have come from incorrectly assuming that
using the new .Recordset object would work the same way as
..RecordsetClone. I don't see that this assumption was warranted at
all, but I can see that it's a logical possibility.
And, of course, it seems to me that it's yet another example of
where the introduction of the useless ADO has compromised basic
Access functionality.
As MichKa explains in his article, the change to ADO navigation in
the bookmark navigation wizard is caused by the desire to make the
code work in both MDBs and ADPs. That seems like a colossally stupid
goal to me, but, hey, what do I know?
I've never understood the use of recordset variables with
.RecordsetClone. What, exactly, are you accomplishing by doing
that, except complicating things?
Find feature on a form, e.g.
set rst = me.recordsetclone
rst.findfirst strCriteria
if rst.nomatch then
msgbox "not found"
else
me.bookmark = rst.bookmark
end if
With Me.RecordsetClone
.FindFirst strCriteria
If .nomatch then
msgbox "not found"
Else
Me.Bookmark = .Bookmark
End If
End With
Um, tell me again why you need to use a recordset variable?
--
David W. Fenton
http://www.bway.net/~dfenton
dfenton at bway dot net
http://www.bway.net/~dfassoc