orderby on a boolean field

[tania20]

Hi, Ive got a set of records that I want to display according to a check box field. I can get it to sort OK but it displays the checked records first, and I want it the other way around. Ive tried using DESC and ASC but it doesnt work. Any suggestions? Thanx

 

[Remou]

Please post the filter that you tried.

 

[tania20]

I tried a range of things...

"fieldname DESC"
fieldname DESC

both in properties and by using OrderbyOn in code

 

[Remou]

Did you try without the quotes? How are you applying this filter?

 

[tania20]

yep i tried with and without quotes in properties and code:

' Me.sfCurrent.Form.OrderBy = "ViewResult DESC"
' Me.sfCurrent.Form.OrderByOn = True

 

[Remou]

Are you sure you have the name of the subform control, rather than the form contained by the control?

 

[tania20]

I use the same when I am applying a filter and that works fine....

 

[Remou]

When you use the buttons on the toolbar to sort decending, what do you get in the OrderBy property of the subform?

I find a mock-up works for me, which is why I am puzzled.

 

[tania20]

The following is returned tblSummaryInfo.ViewResult DESC, where the recordsource of the form is tblSummaryInfo....

 

[Remou]

Well, its a long shot, but you could try that:

Me.sfCurrent.Form.OrderBy="tblSummaryInfo.ViewResult DESC"
Me.sfCurrent.Form.OrderByOn=True

 

[tania20]

Ive tried that and it still doesnt work. For some reason its ordering even when i remove the code and property reference.Very baffled!

 

[Remou]

It looks as if some other code may be interfering. How about trying a test form with nothing but the subform and the order by code?

 

[tania20]

that thought just occured to me...and sure enough....there was some other code overwriting this in a pop-up form!! thanks for yr help!