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 lodg...@gmail.com On 29 March 2013 19:09, Ian Whitfield <whitfi...@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%2bh...@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+h...@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