Preserving Sort Order 1

[infomania]

Using Access 2003 as 2000.

I have a datasheet form which sorts records by two fields (TABLE_NBR Asc, LASTNAME Asc) in a row. After opening the form a user clicks on LASTNAME and sorts Asc. When the form is closed and repoened I loose the sorting order that was built into the query (it retains the user action). Is there anyway to wipe out the user action when the form is closed (or reopened)?

 

[PHV]

Perhaps Me.OrderBy = "": Me.OrderByOn = False

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

 

[infomania]

Thanks, PH That did the trick. I replaced:

DoCmd.Close
DoCmd.OpenForm "frmDS_AUCT_ATTENDEES"

with

Me.OrderBy = ""

For the cbRefresh_Click event and this cleared the user's action.