Subform Sort Order 1

[TerriO]

I have created a form with a related subform and it works well for the creation of a record within it related table. However, the records contained in the subform (related child table) are displayed later, the subform records are not returned in the order that they were entered (based on date or primary key).

How do you specify the sort order of a subform's returned records?



Terri

 

[KenReay]

Hi

A sub form is just a form like any other, so to order the records, you put an order by in the query on which the form is based, or if at present it is based directly on a table, you click the builder button to the right of the recordsource property and make a query with an appropriate order by

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK