Change Sort By order of a report from a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the form that sets up a report to be able to choose the sort order.
Say if Forms!MyForm!MyFrame = 1, then Sort by Creditor Name and if =2 then
sort by date of last payment. Say the report has a report header, a detail
section, but no section headers/footers. Can anyone help me with a code
example. The "help" for OrderBy and OrderByOn did not explain enough.
 
Sorry but my IE V6 browser cannot find the URL you sent me (ending
ser-33.html). Is it correct?
 
Found your article. I suppose it doesn't matter what I set the Grouping and
Sorting Dialog to be because it will be changed by the code. Now, how do I
set the sort order to DESC? Thanks....
 
OK got the answer from on-line help. To set the sort order descending, specify:

Me.GroupLevel(0).SortOrder = True

Thanks for the help...
 
Dear Allen,

I followed your method (see my subsequent posts) and it works great. I open
a form from the report On Open event to obtain the report sort criteria. I
included a button to make the report Visible = False. The next thing in my On
Open event is the line DoCmd.Maximize (so the report appears full size). What
happens is that my get parameters form goes to maximum before it disappears.
That does no harm, but esthetically, I'd like the form to have completely
gone invisible before the Maximize begins. Any suggestion?
 
I meant to say the button on the form makes the Getparameters form (not the
report) visible = false.
 
Try moving the DoCmd.Maximize into the Activate event of the report. Can't
promise, but worth a try.
 
Back
Top