[AccessD] Order By in Subform

Nicholson, Karen cyx5 at cdc.gov
Wed Sep 1 09:18:23 CDT 2004


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





More information about the AccessD mailing list