Order by a date field in a sub form

[arobbo]

i posted this earlier in another forum , wasn't sure if i was actually posting in the correct forum for the problem, appologies for double posting, just wasn't sure which forum to post it in""

Further to my earlier problems which i thought had been resolved, i'm still experiencing order errors with records being displaid in my subform.....

i don't really understand how it is currently ordering my records but its not the way i want them ordered. Is there a possibillity that the subform is getting its order by properties from the main form which also has an order by property set?

if this is the case does anyone know how to set the order by property in the subform to only be on the subform and not inherrit its order by properties..

hope that makes sense

 

[Crowley16]

nope, the subform should have it's ordering seperate, check that you've got the ordering property correct on the subform.

try adding a requery command somewhere to see if that clears it up

--------------------
Procrastinate Now!

 

[arobbo]

a requery command ... sorry thats a bit above my knowledge

"explain as if to a child" lol

i've checked the ordering property in the form properties order by i have got the field name followed by DESC as follows

Nom_Supplier_Sheet_Date_From DESC

is that the correct syntax ?