sorting a subform

  • Thread starter Thread starter Gary
  • Start date Start date
G

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.
 
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.
Click to expand...

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

:-)
 
Back
Top