Alen Browne's Concatenate, some help would be appreciated

[tarenja]

I've recently found Alen Browne's concatenate function; it's brilliant.
Unfortunately I'm not so smart.


I have it working in my application but when I tried to add an extra condition to the "where" part I've run into problems.
It's the last part that's beating me.
"and [tblDelegatesSelectedActivities.ActivityID]=7"
Can anyone point out where I'm going wrong please?

ConcatRelated("ActivityID","tblDelegatesSelectedAc tivities","DelegateID = " & [tblDelegates.DelegateID] and [tblDelegatesSelectedActivities.ActivityID]=7" )

[RuralGuy]

Put your WhereCondition string into a string variable and display it in a MsgBox and you will see your problem.

[June7]

Missing an & and quote mark in the concatenation. Remember: parens, brackets, quotes, apostrophes in pairs.

This function is called in a query that joins tblDelegatesand and tblDelegatesSelectedActivities?

"DelegateID = " & [tblDelegates.DelegateID] & " and [ActivityID]=7" )

[tarenja]

Thank you very much. Works fine now. I hate being stupid!