Order(sort) a field on a subform 2

[Dougpeplow]

I have created a subform linked (using link Child : link master property)on a field which sorts/orders OK nummerically when the form is opened on its own, but whenever the form is opened by the master form, the sort/order is non-logical for the linked field.<br>
The form's source is a table, with the linked field indexed

 

[DougP]

Try using a SQL statement in the &quot;Record Source&quot; of the subform<br>
using the &quot;ORDER BY&quot; parameter<br>
Like:<br>
SELECT DISTINCTROW [Employee].[Name], [Employee].[Age] FROM [Employee] ORDER BY [Employee].[Name];<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[elizabeth]

You can change the form's RecordSource property to a query sorted as you'd like.