Re Q1:
You can use the function in the query (as per the example in the web page),
or in the Control Source of a text box on
your form or report.
Re Q2:
The function arguments are incorrect. Do you have a structure similar to my
previous reply? If so, the first argument would be your CustomerPets table
(not tb_Providers, which would have a unique record for Bill Smith if I
understand you.)
The arguments are explained in the article.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<ve***@aol.com> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
Guess I'm still a novice at the function part of this but two
questions:
1. I eventually want to output to a new table so can I use a query
instead of a form? I took the answer literally.
2. I thought I followed instructions and put
=fConcatChild([tb_providers],[provider_id_co],[hosp_1],[Text],[«varIDvalue»])
in my form. I don't really understand the last field which is "10255"
in the example. I don't know what that's referencing.
I'm trying to take the hosp_1 field (in many table) and concatenate it
with the provider_id_co so I'd have the Bill Smith 123 Smith St. Dogs
and Cats answer above. I'm assuming Bill Smith is the provider_id_co
and Dogs is hosp_1 and Cats is hosp_1. I'm getting a #Name? error.