The code works fine when I have only one criterion. The code is like this:
Expand|Select|Wrap|Line Numbers
- =ConcatRelated("[Allergen]","[Q_Recipe_Allergen]","[recipeID]= """ & [Txt_RecipeID] & """","[ConvWTA]" & "DESC")
Txt_RecipeID is the text box name. ConvWTA is a number field that data sorting is based on.
When I tried to add the second criterion RecipeVersion, I cannot get the syntax right. The closest (not working) one I can get is as below. I got error message “Error 3061: Too few parameters. Expect1.”
Expand|Select|Wrap|Line Numbers
- =ConcatRelated("[Allergen]","[Q_Recipe_Allergen]","[recipeID]= """ & [Txt_RecipeID] & """" & "And [RecipeVersion]=""" & [txtRecipeVer] & """","[ConvWTA]" & "DESC")
Thanks,
Joe