Order By property not working

[cyberpac9]

i have two forms - frmOne and frmTwo. frmOne opens frmTwo with this code:

intVar = Me!l_id
    intRoom = Me!l_room
    stDocName = "l_surveys"
    stLinkCriteria = "[l_id]=" & "'" & intVar & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

on frmTwo i have the property for Order By set to "frmTwo.l_date DESC" but it never orders it by the date DESC....i've even tried to set it using VBA and i can't get it to work properly...

suggestions?

 

[gemma-the-husky]

I think your syntax is wrong - its looking for a field called I_date DESC (maybe not even that).

Lose the DESC and see if it sorts in ascending order, then look at the correct way of wording the descending requirement.

Sort it DESC manually, and see what the order by property gets set to.

 

[cyberpac9]

when i remove DESC it doesn't sort it any longer...then i sort it myself and it adds the DESC back like it had been previously....