On 12/20/2012 04:18 PM, Alexander Thurgood wrote:
Le 20/12/12 14:46, Ian Whitfield a écrit :
Thanks for the feed-back Alex - appreciated!!
OK - I have two Tables (Members and eMails). The "Main Form" brings up
the Members Table with a button to pop-up a sub-Form with eMails that
the Member has sent or I have sent to him/her. (This part I have working
but at the moment it brings up ALL eMails!!)
If your main form already contains the ID of the member, why don't you
use the member ID as a filter criteria for your email form ?
In form edit mode of your email subform, click on the form properties
button, and then click on the three dots button to the right of the
Filter field. This opens a filter dialog, where you can enter a Named
Parameter for your filter, e.g.
MemberID = :ID
If you then save this Filter criteria, you will notice that the Filter
field has been filled. You can then quit the Form Properties dialog and
save your form.
When you open your email subform, you will be asked to provide the ID of
the member and the form will filter the results on the basis of that ID.
(Hope you and everyone had a great Xmas and Best Wishes for 2013!!)
Your reply to me has made me change my layout of my Forms. I have
removed all fields from my Sub-Form except the two IDs, the date,
Sent/Received box, Message title and the message itself. The Button on
the main Form I have re-labeled as "eMails".
So all I need now is for the Sub-Form to AUTOMATICALLY pick-up the
Members ID from the main Form and to use as the filter criteria for
which eMails to show. (I will also use this form to enter new eMails so
the automatic pick-up of the Member's ID is also important here).
I have tried a couple of syntaxes to do this with no luck - it always
asks me for the Members ID!!
Is there a way to automate this?
I thought that I could use 'MembersID' (on eMail SubForm) =
'SchemaName.TableName.FieldName' would work but so far no luck.
Thanks for any advise.
For unsubscribe instructions e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy