Can't Sort records in Subreport

[Lateral]

Hi Guys

I'm a newbie and am playing around with a template that I downloaded from the Microsoft Access template website. I am using Access 2007.

I have a report that has 2 subreports within it.

One of the sub reports input is from a table (Work Order Parts) whose records have a field called "DisplayOrder". This is a numeric field that I use to enable the user to specify the exact order that they want the records to be displayed in a form or report...well that's the plan anyway.

I can't seem to get the subreport to sort on the "DisplayOrder" field.

I have tried to set the Property value "Display Order" to "[Workorder Parts].DisplayOrder" but this doesn't seem to make a difference. The "Order By on Load" is set to "Yes".

Here is the "Record Source" value : SELECT DISTINCTROW [Workorder Parts].*, Parts.PartName, [Workorder Parts].Notes FROM Parts INNER JOIN [Workorder Parts] ON Parts.PartID = [Workorder Parts].PartID;


What am I doing wrong???

Thanks for your help

Regards
Greg

 

[pbaldy]

Have you set the sort in Sorting and Grouping?

 

[Lateral]

Hi Paul

Probably not as I have no idea where those setting are....tell me how to find them and I will check.

Regards
Greg

 

[pbaldy]

On the ribbon with the report in design view, not sure what tab offhand.

 

[Lateral]

Found it!!!! Yeah!!!

Thanks Paul!

Regards
Greg

 

[pbaldy]

Happy to help!