How stay on the original record after changing the record order 1

[rew2009]

I am using a form with a record source from a query. How stay on the original record after I change the sort order from within a cmd button. I am using the code:

Me.OrderByOn = False
Me.OrderBy = "Client DESC"
Me.OrderByOn = True

Thanks

 

[TheAceMan1]

How are ya rew2009 . . .

Perhaps the following. Note the primarykey is assumed to be numeric. If text ... changes are required accordingly:

[blue]   Dim Cri As String
   
   [b]Cri[/b] = "[[purple][B][I]Your!PrimarykeyName[/I][/B][/purple]] = " & Me![[purple][B][I]Your!PrimarykeyName[/I][/B][/purple]]
   
   Me.OrderByOn = False
   Me.OrderBy = "Client DESC"
   Me.OrderByOn = True

   Me.Recordset.FindFirst [b]Cri[/b][/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[rew2009]

It looks good, I'll try it, Thanks

 

[rew2009]

It Worked Perfectly, Thanks TheAceMan1