Sorting records in a subform

[John Potter]

How do you sort records in a subform so that whenever the
main form is opened, the records in the subform show in a
particular order? i.e. a permanent sort

Thanks for any help in advance,

John

 

[Douglas J. Steele]

Use a query with an appropriate ORDER BY clause as the recordsource for the
subform.

 

[John Potter]

Thanks

-----Original Message-----
Use a query with an appropriate ORDER BY clause as the recordsource for the
subform.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






.