Re: Simple SortOrder Emulation

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 04/25/04 

Date: Sun, 25 Apr 2004 14:43:32 +0800

Set the form's OrderBy property:

AZ button's Click event procedure:
    Me.OrderBy = "BldgLocations"
    Me.OrderBy = True

ZA button:
    Me.OrderBy = "BldgLocations DESC"
    Me.OrderBy = True 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mike Boozer" <mboozer@wi.rr.com> wrote in message
news:%23Zhjs9iKEHA.3216@tk2msftngp13.phx.gbl...
> I want to emulate the AZ & ZA menu buttons with a graphic. On click, the
> field, "BldgLocations" would be sorted ascending with AZ and descending if
I
> click on the ZA icon. I have no idea of the code. Everything I can find
> deals with queries, reports, or lengthy vb code. Is there a simple way to
do
> this, like:
>
> Me.BldgLocations.SortOrder = True
>
> Or somethingt similarily simple? Thanks.
Quantcast