I have a customer form that uses a subform called "notes" that lists all relavent notes and is ordered by the date they are created. So on the Form I have in properties under ORDER BY "Notes.Date.DESC" This works and lists the notes in the correct order.
Now I also have a button to add notes which opens a form called "new notes" and when you type in the notes and click the close botton I have a command line that refreshes the orginal page to update and include the new notes then close the screen the notes were added in. But when the customer form refreshes all the notes in the subform go out of order and are no longer in DESC order.
Now if I close the customer form and then reopen it, the notes are back in the correct order again. Why isn't the refresh command giving me this effect? Any recomendations?
but no luck. I just don't get it, because the subform refreshes and shows the new notes. I just dont understand why its not ordering the notes in dec order like it does when the page originally loads. I've been tooling with this all day and no luck. Thanks for the idea though.
I tried the code but couldn't get the command to work. I must be typing something wrong, I tried pretty much word for word what you wrote above. Here is the info of all the names of the forms and objects. Could you please write the code again word for word what I have to type.
Form - CreditorInfo
Subform (object name) - Child30
Form that subform gets info from - Notes
Text box to order info by in subform - Date