i have a form which shows organisation details from an organisation table once a search has been performed on the organisation table.
the organisation table is linked to a contacts table which holds employees information.
i want there to be a button on the organisation details form that will get a list of all the employees email addresses for all the organisations in the recordset for whatever has been searched. the email addresses need to be seperated by " ; " . this will then be used to send an email.
i have got my self all in a muddle and the code i need is very urgent.
the code i have i have pasted below and there are errors to do with the sql. and setting the recordset rst.
if you can see of a better way to do this than i have done or can see where my problem lies please tell me :)