Simple SortOrder Emulation

[Mike Boozer]

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.

 

[Allen Browne]

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

 

[Mike Boozer]

Thanks Allen. Works great now that I got my db up and running again.