I need to sort a report based upon user input from a form. The form
has a custom list of names corresponding to field names in the
report's recordsource. The user chooses a name then either ascending
or descending and then clicks print. The problem is that I can not put
the report into design view since this will be for an application
being run as an mde.
Thanks,
Brian

Brian,

In cases where just changing the WHERE clause won't do it for you, you
can build the recordset on which you want the report based in runtime,
giving you complete control over it. Detailed instructions and sample
code can be found in an MVPS Access FAQ topic.

MVPS Access FAQ
Use a recordset as report's datasource
http://www.mvps.org/access/reports/rpt0014.htm

- Hammer

---

Request for Answer Clarification by bselltiz-ga on 05 May 2003 20:52 PDT

I like this technique - pretty cool. Only problem is that the report
will still not sort correctly. Any other changes to the recordsource I
make show up correctly and even if I copy the string into a query the
query will sort the way I want. It just won't do it in the report. Any
idea why this might be happening?

---

Clarification of Answer by hammer-ga on 06 May 2003 04:37 PDT

Brian,

Are you forcing a different sort order in the report design using the
Sorting and Grouping dialog? If clearing that doesn't help, could you
upload an mdb with enough elements for me to help troubleshoot this?

- Hammer

---

Request for Answer Clarification by bselltiz-ga on 06 May 2003 08:27 PDT

ya, I have some other grouping going on and apparently it is
interfering with my attempt to sort it. No big deal, I figured out a
work around using part of what you showed me before, so I'm good to
go.
Thanks for your help, talk to ya soon :->

---

Clarification of Answer by hammer-ga on 06 May 2003 08:33 PDT

Excellent. Good luck with your deployment!

- Hammer

Hammer getting me what I need as usual :-> Thanks!