Ok, I think I get what you mean. I checked this answer you had given earlier and thought that the same thing might apply:
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: Code:
=sortfield("fieldname", "formname")
then write a universal function like this: Code:
public function sortfield(fld as string, frm as string)
forms(frm).orderby = fieldname
forms(frm).orderbyon = true
forms(frm).requery
end function
\\
Unfortunately, when I tried to do this, it didn't work. I would click the button and nothing would happen. I think I might be getting confused somewhere; should I be replacing "formname" with the form (List) I'm working in, the table where the records come from or the query that stores all the fields?
Or am I way off altogether?
Thanks again,
marty