I have a form that pulls a subform called "notes." The notes are little memos etc. on each client. The subform shows a list of all notes associated with that particular client (it's a continuous form).
1. I know how to sort oldest to newest and vice versa, but I want it to show me the newest note with the cursor in a new blank note. In other words, I want to be able to quickly add new notes, but also see the latest notes. Ordinarily, regardless of sort, the "new" note is always at the bottom of the list.
2. Say a note is longer than fits in the form. Can I have the field auto-expand? I tried setting the autoexpand property to yes but it didn't do anything. What am I missing?
I attached a sample database saved in 2003 format.