Sorting Subform from cmd button

[DMT Dave]

Hi Guy's, i have tried looking to see how i can sort a certain field on a subform from a command button



this works to sort A-Z

Me!frmItemsData.Form.OrderBy = "Carbs"Me!frmItemsData.Form.OrderByOn = True

I now want to sort Z-A ?

tried changing OrdbeyOn to False but that appears to change to original sort order (RecordNo) integer

Thank you

[Bob Fitz]

Try:

Me!frmItemsData.Form.OrderBy = "Carbs Desc"
Me!frmItemsData.Form.OrderByOn = True

[DMT Dave]

Bob, it was as simple as that, why i couldn't see that I'll never know

I do use ASC or ; and DESC quite frequent in SQL statements but did not cross my mind!!

Thank you very much indeed

[Bob Fitz]

Bob, it was as simple as that, why i couldn't see that I'll never know

I do use ASC or ; and DESC quite frequent in SQL statements but did not cross my mind!!

Thank you very much indeed

Sometimes, the most obvious can be the most elusive and always pleased to help if I can