I am trying to use the ConcatRelated() function and am having problems passing the "Where" argument when I use a value from a form.
ex ConcatRelated('[txtError]','[tblWorkload]','[tblWorkload].[Analyst] like [AnalystNameonForm]','',' Delimiter').
My first question is why I only can seem to get the function to work if each is enclosed by an apostrophe. I see the examples always use quotation marks. I have the same issue with builtin functions like Dlookup.
Secondly, I can get this to work if I type in the [AnalystNameonForm] surrounded by quotes like the example, but if I try to use the value of the field, I get errors for too few arguments. I can also get this to work if I put the above argument directly into the module.
Thanks for any help