[AccessD] Using the Bookmark property

Arthur,
Should try this ?


Private Sub cmdSortName_Click()
    With Forms!frmETEMS
    .OrderBy = "fieldName"
    End With
DoCmd.RunCommand acCmdApplyFilterSort
End Sub

Willy


----- Original Message ----- 
From: "Arthur Fuller" <fuller.artful at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, December 21, 2007 01:36 AM
Subject: [AccessD] Using the Bookmark property


>I have a continuous form, on whose footer is a button to allow editing of
> the selected row. A dialog pops up, allows editing, then closes. The 
> record
> selector keeps returning to the first record rather than the just-edited
> record. I cannot remember how to use the bookmark property to grab the
> record about to be edited, then return to it following the edit.
>
> TIA,
> Arthur
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com