Order of records in subform

[garywood84]

I have a form with a subform. I want the records on the subform to be in alphabetical order of first name. At the moment, they appear in the order the records were entered.

I have opened up the subform itself in design view and specified the record order. If I then switch to form view for this, the records correctly display in alphabetical order.

However, when this form is displayed as the subform, the ordering reverts to the original order of record entry.

How can I change this?

Thanks,

Gary

 

[RV]

Base your subform on a query.
Sort on the appropiate column in your query.

RV