Thanks Noel On 29/03/13 13:13, Marion & Noel Lodge wrote:
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
I tried this and it seems to remind me that I used something like this before!!
However when I try it and "press the button" on my Main Form it takes me to the Macro Edit window and I can not close this as it says "Basic is still running"!!
Should I be linking to my Table or to my Form?? Otherwise any other ideas?? Thanks a lot IanW Pretoria RSA -- For unsubscribe instructions e-mail to: [email protected] 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
