I have a subform with various columns. At the top of each column there is a
button that the user can click to sort the form using the column field.

Clicking the button calls this function

Public Function SortForm(frm As Form, ByVal sOrderBy As String)
On Error GoTo Err_SortForm
'Purpose: Set a form's OrderBy to the string. Reverse if already set.
'Usage: Command button above a column in a continuous form:
' Call SortForm(Me, "MyField")

If Len(sOrderBy) > 0 Then
' Reverse the order if already sorted this way.
If frm.OrderByOn And (frm.OrderBy = sOrderBy) Then
sOrderBy = sOrderBy & " DESC"
End If
frm.OrderBy = sOrderBy
frm.OrderByOn = True
End If

Now when the user exits the form I make a note of which button was clicked
last.

Question - how do I make sure the form is sorted by that column when it
next opens?

"buckskin" <bucko (AT) mailinator (DOT) com> wrote in
news:9l672aF3gqU1 (AT) mid (DOT) individual.net:

event to query that table and load your variable from the table.


--
Bob Q.
PA is y I've altered my address.

"Bob Quintal" <rquintal (AT) sPAmpatico (DOT) ca> wrote

Thanks. So i'll need to modify my query using that value when it loads up.
I'll see if I can get that done.