Hi Ian, Not sure if this is what you need, but it works for me. I got it from the Web. On the Events tab of my button under 'Mouse button pressed', I connect to the sub, OpenfMembers(). If you substitute your form name in place of "fMembers" I think it should work for you too. Sub OpenfMembers(oEvent AS Object) OpenForm("fMembers") End Sub Sub OpenForm(FormName AS String) With ThisDatabaseDocument.currentcontroller If Not .isConnected Then .Connect End if End With ThisDatabaseDocument.FormDocuments.getByName(FormName).open End Sub Noel -- Noel Lodge lodgemn@gmail.com On 29 March 2013 19:09, Ian Whitfield <whitfield@telkomsa.net> wrote:
Hi All I need some help again!! I did this a few months back but now can not remember how I did it!! I have a Main Form of Member details working well and this has a SubForm showing eMail to and from this Member. Now I want to add a Button to the Main Form that opens a window on top of the Main Form and this window contains a second Subform with some other information. I have created the table for the second Subform and put the Button on the Main Form but can not remeber how I got it all to work!! Any help would be appreciated!! LO Base 3.6.5.2 linking to MySQL 5.1.55 IanW Pretoria RSA -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org <users%2Bhelp@global.libreoffice.org> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette <http://wiki.documentfoundation.org/Netiquette> List archive: http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> All messages sent to this list will be publicly archived and cannot be deleted
-- For unsubscribe instructions e-mail to: users+help@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