Macro Button to Sort Field A-Z

[rdirosato]

Hello,

Say I have a report or form with some columns like below


Name.........Number........Phone


Rob............222..............222
Joe.............111..............333

What I'm trying to do is create a macro that when the title name (Name Number Phone) is clicked it will sort the column a-z

Thanks in advance for your help

[ajetrumpet]

i believe you do this using the ORDERBY property. so on the click on each label that holds the field names, put something like this on the click event property:

=sortfield("fieldname", "formname") 

then write a universal function like this:

public function sortfield(fld as string, frm as string)

forms(frm).orderby = fieldname
forms(frm).orderbyon = true
forms(frm).requery

end function