[AccessD] Order By in Subform

Karen:

I think doing a global replace on the name would be the quickest way.  Do
you have Find and Replace, Speed Ferret or some other third party add-in?  I
use Find and Replace and that would change all the references even in the
object names.

HTH

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Nicholson, Karen" <cyx5 at cdc.gov>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, September 01, 2004 7:18 AM
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