OrderBy property not working 1

[cssilver]

I set the OrderBy property of a subform to "studentLastName,studentFirstName" (I tried it both with and without quotes), yet the form does NOT display them in alphabetical order.  Am I doing something wrong?

 

[DougP]

Try this instead.<br>In the &quot;Record Source&quot; of the form. Click in it then click the &quot;3 dots&quot; button. If it asks do you want to Invoke query buider clik &quot;Yes&quot;.<br>Drag all of the fields you need in your form down to the QBE grid below.<br>Make sure that studentLastName is to the left of studentFirstName. OK<br>Click in the Sort box under studentLastName and pick Ascending do the same for studentFirstName.<br><br>Next close the Query, when it asks do you want to save click &quot;Yes&quot;<br>When you view your form it should be correct.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.