Setting record sort order in subform

[njitter]

Hello,

i have got a form with a linked subform. I would like to have the subform display it's records in reverse order (by ID).

I have been unable to set the sort on this subform

Search did not come up with a solution..

---
It's never too late to do the Right thing

 

[PHV]

Take a look at the DESC option of the ORDER BY clause.

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

 

[njitter]

This was the first thing i did try.

OrderBy : Guidance_ID DESC



---
It's never too late to do the Right thing

 

[PHV]

You must also set the OrderByOn property to True.

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

 

[njitter]

Yes!

I did this:

Private Sub Form_Open(Cancel As Integer)
Me.OrderByOn = True
End Sub

and this:

Private Sub Form_AfterInsert()
Me.Requery
End Sub

along with the OrderBy in the Form.

The Subform works like i intended it to work now...


---
It's never too late to do the Right thing