A2003: order records on subform

[bulrush]

I have a main form, let's call it ProjectEdit, with a subform called ProjectDetailEdit. When the main form ProjectEdit is shown, it shows only the detail records linked to the main record. But the detail records are not sorted. The recordsource of ProjectDetailEdit is the table, not a query, at present.

I want to sort the detail records, as shown on the main form, by a field on the subform called ItemName.

I put ItemName in the OrderBy field of the subform, but that didn't seem to change the order.

Also, my subform is displayed as a continuous form so I can use an edit button for each detail record. It is not displayed as a datasheet.

Thank you.

 

[jdraw]

Have you tried making the subform's record source a query in which the data is sorted the way you want? Would seem a good place to start.

 

[bulrush]

Found a link:
http://www.access-programmers.co.uk/forums/showpost.php?p=1063735&postcount=2

I put the code in my main form's Activate event and it works.

 

[Johnny]

Thanks for posting that link I had the same problem which was solved through that link.