Form Data

[FadingAPE]

Hello,

I've created a notice board for my database and I have one tiny problem. As someone eneters a message I want it to appear at the top of the notice board. What I have dont is set up a table and a form linked to this. Within the table I have made a DateEntryMade column and sorted the data so it goes in descending order however when I genterate a form it still has the oldest message at the top. How can I fix this???



It works fine on its own but it is a subform - when its a subform it doesnt work


Thanks
Laura

[michaeljohnh]

Sounds like you need to modify the SQL source statement for the subform. At the end of the statement add Order By [tablename].[fieldname].