Field 'Ascending' problems in Forms

[mpasschi]

MS Access 2002, in Windows XP.

Hello all, could you please have a look at this problem description?
I have a Query that shows in 'Design view' two fields in which the "Ascending" option is selected.
When opening the Query it shows exactly these selections, and both field are running ascending, so till now no problem.
Out of this Query I have a Form attached which shows one Field as in the linked query (so ascending) but the second Field does not show the ascending sequence

Most probably I missed something in the Field properties when running the Forms 'design view' or is this a bug?

Thanks in advance!!

[aprpillai]

Open your Form in Design View. Display the Form's Property Sheet. Put the Field Names in the Order By Property like the example given below:

Employees.FirstName,Employees.LastName

Employees is equal to your Query Name.

Copy the following code into the Form Module and save it.

Private Sub Form_Load()
   Me.OrderByOn = True
End Sub

a.p.r. pillai
** Link Removed **

[mpasschi]

Thanks aprpillai, problem solved!