forms subforms and sorting by date fields

[arobbo]

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

 

[DeMann]

If you go to the properties of the subform, go to the data tab, and go into the record source, you should be able to setup your sort there. Similar to design view of a query.

_______________
conceptNEXT.com
[cN]

 

[arobbo]

i thought of doing that however i want to be able to update data in the subform... if i use a query will i be able to update the subform data?

 

[arobbo]

YES !!!

being trying to get that to work all bloody day


thank you so much ....

may you live long and prosper lol

 

[DeMann]

LOL!!

_______________
conceptNEXT.com
[cN]