sorting a subform

[Gary]

I have a form already open that also has a subform open.
Using VB how can I sort the subform data. I need to be
able to click a command button and make this happen.

I have Access 2002 running on XP Pro

Thank you.

Gary.

 

[Bruce M. Thompson]

I have a form already open that also has a subform open.

Using VB how can I sort the subform data. I need to be
able to click a command button and make this happen.

'***EXAMPLE START
With Me.SubformControlName.Form
.OrderBy = "[FieldName]"
.OrderByOn = True
End With
'***EXAMPLE END