Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.
dim strOrderBy as string
strOrderBy = me.subformcontrolname.form
strOrderBy = "[FieldName]" & Iff(instr(strOrderBy, "DESC") =0, " DESC", NULL)
me.subformcontrolname.Form
me.subformcontrolname.Form
ENd Sub
Note: you must replace "subformcontrolname" with the name of the subform control as it is seen in the Name property when viewing the main form in design view. Do not confuse this with the subform's sourceobject.