Sorting a Field

[Rusty]

Hey Guys,

I have a comand button on a form and I want it to select a field called [DateOfMI] and sort it (in ascending order).

So far I have got the code below, but what do I need to put before it to select the [DateOfMI] field?

Any ideas?

Rusty

Private Sub cmdSortDateMI_Click()

    DoCmd.RunCommand acCmdSortAscending

End Sub

 

[Kodo]

it would make sense to me that you would have to set the focus to the control that you want to sort on.

 

[Rusty]

Thanks for that,

I managed to use the code below to do just that.

Cheers,

Rusty

Private Sub cmdSort_Click()
    Fieldname.SetFocus
    DoCmd.RunCommand acCmdSortAscending
End Sub