Simple SortOrder Emulation

  • Thread starter Thread starter Mike Boozer
  • Start date Start date
M

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.
 
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
 
Back
Top