Hi Ian, There is another way -
1. After opening your Form in design mode, click on View | Toolbars | and make sure Form Design is ticked 2. On that toolbar, click on Form Navigator (5th from left on my toolbar - it's the one with the 4 point star on it) 3. Right click on your Form name (probably the 2nd item from the top) 4. Choose Properties 5. Continue from point 3 on my first reply If that doesn't work, then someone who uses Forms with MySQL may be able to help you. Noel -- Noel Lodge lodg...@gmail.com On 29 August 2013 17:55, Ian Whitfield <whitfi...@telkomsa.net> wrote: > Hi Noel > > On 29/08/13 06:12, Marion & Noel Lodge wrote: > >> Hi Ian, >> >> With a Form, I have found the following is the way to lock in the Form's >> sort order - >> >> 1. Open the Form in Edit mode >> 2. Right click on the form and from the dropdown choose Form... >> 3. Click on the Data Tab >> 4. The contents field should be pointing to your Table >> 5. Click on the box to the right of the Sort field >> 6. Then you can choose your sort fields, (LastName and FirstName) >> 7. Click OK >> 8. Close Form Properties >> 9. Save the Form >> >> This works with my H2 database. Hopefully it is the same for your MySQL. >> > > Just checked on my OLD Base / HSQL Database and there is NO "Form" option > there either - so I guess this is an option only with your H2 engine (??) > > IanW > Pretoria RSA > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted