There is probably a simple solution to this however I have yet to stumble upon the answer. I need to be able to take records from a subform (2 columns) and place them into an unbound text field so that I can reference this field in an email through VB. The email part is in the bag but the subform is holding me back.

Has anyone done this before? Any help would be greatly appreciated.

JONP

[This message has been edited by jonp (edited 02-12-2002).]

I think this article will help you in referring to a subform.

http://support.microsoft.com/support/kb/articles/Q209/0/99.ASP?LN=EN-US&SD=gn&FR=0&qry=subforms&rnk=5&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Thanks Jack for your quick response. I appreciate that. But if my subform contains more then one record, how do I concatenate these separate records into one unbound field?

JONP

Me.FieldOnMainForm = Me.SubformName.Form.Field1 & " " & Me.SubformName.Form.Field2

Is that what you are after?

Hi Jack,

That is part of what I need to do but my problem is with the remaining 3 or 4 records within the subform. I can reference the subform in an unbound control but it will only display the first record within the subform. How can the remaining records be captured?

Many thanks,

JONP

[This message has been edited by jonp (edited 02-13-2002).]