Problem ordering records on a report

[badulake1]

Hi there,

I have (on Access97) a form that has a list that can be reordered on runtime. On the same form I have a button to print the Rowsource of this list item. However, even though the list is ordered, the report always prints in the same order. This is how I open the report:

DoCmd.OpenReport stDocName, acPreview, List.RowSource

The problem is, as I said, the report doesn't show ordered. I tried something else which was to set through vba (after the OpenReport) the OrderBy and OrderByOn properties but nothing happens (guess I should have to refresh the report since it has already been opened). Can anyone help?. Thanks in advance,

Javier

 

[mdthornton]

check and/or set up values in the sort/order by pop up.
you get to this via view->sorting/grouping menu. Best Regards,
Mike

 

[badulake1]

On Access 97 there's no view->sorting/grouping, and if there was I wouldn't want to use it everytime I print a report which source (List.Rowsource) is already filtered and ordered (why re-order?). The filter is applied, however, I can't manage to sort the records using the OrderBy and OrderByOn properties.... it can't be that difficult!!

 

[mdthornton]

Look again my friend....

Report design, then open view->sorting/grouping Best Regards,
Mike

 

[badulake1]

Thanks a bunch Mike. My problem was that since there was already an order there, I couldn't specify one myself (it was ignored). The solution:

1) I deleted all the columns in the order/group list
2) After calling Open Record, I issued the sentence:
Reports![MyReport].OrderBy=Field1

Bye,

Badu