Concatenate subform records

A

ancient_hilly

Hi, I'm trying to concatenate a field from all records in a subform to
display on the parent form. I have found the following link which will do
what I want.

http://www.mvps.org/access/modules/mdl0004.htm

But try as I might I cannot get this to work for me.

I created a new module for the fConcatChild function and tried inserting the
query into the control source for the unbound field on the main form. No
matter what I try I only get a #name? error.

Can you please advise, as simply as possible, what I have done wrong &/or
what more I need to do.
Thanks
 
Top