Using Checkboxes to sort report

[lovett10]

Hi thanks in advanced for any help.

I have 3 checkboxes in my form i wish to when checked and search button is pressed to open the report and sort it by the corresponding field

heres what i have so far...

If Me.chkQuoteNumber.Value = True Then

yea not alot i think i might need to use OrderBy somewhere but arent really sure how it works.

P.s My report is called "VisitSheetTableReport" and for this example my field that i want to sort is called "Quote Number"

P.P.S I am using Access 2010

P.P.P.S thanks for any help much appreciated

 

[vbaInet]

Isn't this thread related to this?

http://www.access-programmers.co.uk/forums/showthread.php?t=219532

 

[lovett10]

Isn't this thread related to this?

http://www.access-programmers.co.uk/forums/showthread.php?t=219532

Sort of except that thread is about search functionality this is about sort. I thought it would be better to keep them seperate so as not to confuse people and me.

 

[vbaInet]

You first need to build the SQL statement then pass it to the report's OrderBy method. The other thread deals with the main part of this process, i.e. building the SQL.

 

[lovett10]

You first need to build the SQL statement then pass it to the report's OrderBy method. The other thread deals with the main part of this process, i.e. building the SQL.

So i need to Select my report first?

 

[vbaInet]

You need to open the report first, then apply a sort on it. That's the easiest way. There's a more complicated way which requires more coding but it allows more flexibility.

 

[lovett10]

You need to open the report first, then apply a sort on it. That's the easiest way. There's a more complicated way which requires more coding but it allows more flexibility.

 DoCmd.OpenReport "VisitSheetTableReport", acViewReport, , strFilter

Then how do i select the report to apply the sort?

 

[vbaInet]

Reports!VisitSheetTableReport.OrderBy = "[QuoteNumber] DESC"
Reports!VisitSheetTableReport.OrderByOn = True

 

[lovett10]

Reports!VisitSheetTableReport.OrderBy = "[QuoteNumber] DESC"
Reports!VisitSheetTableReport.OrderByOn = True

I take it i can change the DESC to ascending somehow?

 

[vbaInet]

That was just an example of what you can do. You can put ASC if you want.

 

[lovett10]

That was just an example of what you can do. You can put ASC if you want.

Ok thanks very much for your help.

 

[vbaInet]

Does that answer your OP?

 

[lovett10]

Does that answer your OP?

I think so thanks alot

 

[vbaInet]

You're welcome!