Syntax question

[Del]

What is the syntax for the Order By property of a form?

I need to display records where the field [Ref Des] is in ascending order

 

[Del]

I need to be more specific.

I need to know what the syntax is for the Order By property of a subform
with its Default View set to Continuous Forms.

The syntax is what I thought it would be in a regular form but does not work
in my subform

 

[John W. Vinson]

I need to be more specific.

I need to know what the syntax is for the Order By property of a subform
with its Default View set to Continuous Forms.

The syntax is what I thought it would be in a regular form but does not work
in my subform

The OrderBy property is simply a fieldname, in square brackets if the field
name contains blanks or other special characters; or a series of fieldnames
separated by commas if you want to sort by multiple fields. The form's
OrderByOn property must also be set to Yes (and this needs to be done in code,
I don't think you can set it manually).

 

[Del]

Thank you John. I was not setting OrderByOn = True.