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

Reply via email to