Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Le 18/12/12 12:04, Ian Whitfield a écrit :

Hi Ian,

On my Main "Membership" Form I have added a button to bring-up the eMail
SubForm. (I have this part working!) But what I see as the best way to
do the last step is to add a ListBox named "Find Member" to the SubForm
and this will read from a Query holding the concatanated First Name and
Surname of each Member and that Member's ID Key. Once these are inserted
into the SubForm it will extract all the relative eMails, sort them into
date order and display them.

What do you mean exactly by "inserted into the Subform" ? Your e-mail
subform just contains e-mails, or does it hold something else ? I
imagine that there is a foreign key reference to the member in the
e-mail table ? I'm a bit confused about what you're trying to achieve here.

So - Questions and Advice please on the following...

 * Is this the right way to approach this requirement?
 * Will the Query update automatically each time it is called so as to
   pick-up new eMails?
 * How do I make the ListBox 'read' the results of the Query?
 * How do I make these results automatically insert into their
   respective fields on the SubForm?
 * How do I make the SubForm do the sort as a final step? (Maybe a
   'Sort' Button??)

As far as I can see, the only way to achieve what you want to do is via
macros, as it looks like you want to retrieve a dataset from a filter or
query, and then inject part of the information from that dataset into
another table ?


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.