Report sorting

[Phillip]

Hi,
I have a continious form that displays four fields for each records of a
table. On the form I have a sort button for each of the four fields which
sorts the records based on the field selected. I also have a report button
that prints a report that produces one page per record. My problem is that I
want the report to be in the same order that the records appear on the screen
which is based on the sort selected.
How do I get my report to print in the same order as the records appear on
the screen?
Your help would be appreciated.
Thanks,

 

[Duane Hookom]

I would use some code to extract the sort of your report (you didn't say how
you created this) and then uses the code from Allen Browne's page
http://www.allenbrowne.com/ser-33.html.