same parameters different sorting for the same form

[Guest]

I have a parameter query that asks for [Last name], [First Name] and sorts by
[Last name], [First Name]. A form uses this query. No problem here.
The users sometimes want to sort the data (on the form) by:

, [Last
Name], [First Name] or by: [Date], [Last Name], [First Name] . [Code] and
[Date] exist in the query/form they are not parameters. I created a coomand
button for each sort: by [Code] and by [date]; however, the parameters must
be re-entered everytime. Uses don't like that.
Any ideas?

Thanx

 

[Guest]

If the query asks for [Last name] and [First Name] then what is there to sort

 

[[MVP] S.Clark]

Add a couple of text boxes to the form that act as the popup paramters do
now. As long as the user's keep the values entered there, they won't have
to retype.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Van T. Dinh]

You probably requery the Recordource rather than using the OrderBy and
OrderByOn Property which is more appropriate if you simply want to re-order
the rows in the RecordSource.

Post you CommandButton_Click code if you need further help.

HTH
Van T. Dinh
MVP (Access)