Change RecordSetType - Form refreshes

[Fonzie]

On my form I have an edit button that changes the recordsettype of the form. When I do this it requeries the form and goes to the first record. How can I make it stay on/go to the record I was on when I hit the edit button?

 

[PHV]

A starting point:
Dim myBookmark
myBookmark = Me.Bookmark
Me.RecordsetType = 0
Me.Bookmark = myBookmark

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Fonzie]

This sounds like what I'm looking for, but I get the error:

Run-time error '3159'
Not a valid bookmark

Any ideas?

 

[PHV]

So, changing the RecordsetType seems to instantiate a brand new recordset ...
1) save the value of the actual record's primary key
2) change RecordsetType
3) use the Me.Recordset.FindFirst method with the value stored in 1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Fonzie]

That works perfectly, thank you. However, if I had a filter applied before I change the recordsetype, is there a way to pass that same filter on after the requery?