Sorting a form

[Secret Squirrel]

I have a continuous form that is currently tied to a query that is sorted by
my field "LastName". I also have a field called "StartDate". Is there a way I
can put 2 command buttons on my form header that will allow users to sort the
form by either of these two fields? One button for each field sort.

 

[Wayne-I-M]

Hi

Have a look at this link

http://groups.google.com/group/micr...2/bf89b93c746ccad1?lnk=st&q=#bf89b93c746ccad1

 

[Secret Squirrel]

Thanks Wayne!

Hi

Have a look at this link

http://groups.google.com/group/micr...2/bf89b93c746ccad1?lnk=st&q=#bf89b93c746ccad1

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ListBoxSorting2k.mdb" which illustrates how to do this.
Although the sample name says Listbox, it also shows how to do it in a
subform.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L