Form & Query help

[Jay]

Hi,

I have a form designed to compile an email based on database records and
enables the user to open MS Outlook and have the email already populated.

The form's Record Source is a query - qryCurrentRecord. That query is based
on two tables where the field StaffName from 'tblQueryDetails' is linked to
the field StafffName from 'tblEmailAddresses', enabling the email address
for that staff member (tblEmailAddresses.StaffEmailAddress) to be returned
by the query.

So on my form I have a text box representing the 'To' address for the email,
the Control Source for which is the field 'StaffEmailAddress' from the above
detailed query.

I have a second, almost identical query in which a second staff member's
email address is returned. My question is, I want to add this field
'StaffEmailAddress2' from this query to my text box, so that both email
addresses are included.

How do I do this, if my form's record source is a different query and my
text box's control source is a different field.

Can I add a second field from a different query to my text box?

Any help would be greatly appreciated.

(Apologies if my explanation is a little muddled

Jason