[AccessD] Order By in Subform

Got it.  Overthinking, I suppose.  This works:

Me.OrderBy = "tasknumber"
Me.OrderByOn = True

Any objections?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson,
Karen
Sent: Wednesday, September 01, 2004 10:18 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Order By in Subform


Syntax, syntax.  The prior programmer used a pound sign in the subform
name.  I am trying to place on 'on click' event procedure to sort the
subform by the task number field.  I am getting a syntax error with this
code:

Me.[frmSortTask#].Form.OrderBy = "TaskNumber"
Me.[frmSortTask#].Form.OrderByOn = True

Any ideas?

Karen Nicholson
National Laboratory
Xerox Global Services


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com