same parameters different sorting for the same form

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

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:
Code: 
, [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
 
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
 
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)
 
Back
Top