Concatenate values from related records - not working (1 Viewer)

[Wozza]

Hi, I am using Allen Browne's function to try and concatenate values from a related record in a form. However, the concatenated field is not working properly.
This is the table

So I need 20FUN02 - JCM, ICFO. In the form, it is coming up as

The code for the guarantee list is :
=ConcatRelated("LE_shortname","MT_guarantee_list","REF= " & "[ref]")

The list does not even match the ref, it appears for all records. Any help would be gratefully received.

Many thanks

 

[Minty]

Take the quote away from the second ref - you aren't creating the criteria correctly.

ConcatRelated("LE_shortname","MT_guarantee_list","REF= '" & [ref] & "'")

 

[theDBguy]

Hi. Just for future reference, you might care to take a look at this simple function as well. Cheers!

Code Snippets

 

[Wozza]

Take the quote away from the second ref - you aren't creating the criteria correctly.

ConcatRelated("LE_shortname","MT_guarantee_list","REF= '" & [ref] & "'")

Feel like I'm so close! It's now coming up with this....

 

[Wozza]

Hi. Just for future reference, you might care to take a look at this simple function as well. Cheers!

Code Snippets

Thank you. Yes I will take a look.

 

[theDBguy]

Thank you. Yes I will take a look.

If you do give it a try, maybe you could start with something like this.

SimpleCSV("SELECT LE_shortname FROM MT_guarantee_list WHERE REF='" & [Ref] & "'")

Edit: For some reason, the forum software wouldn't let me finish the above code. I need to insert a double quote + single quote + double quote just before the closing parens.

Edit2: Ah, never mind. It finally let me do it. Cheers!

 

[Wozza]

If you do give it a try, maybe you could start with something like this.

SimpleCSV("SELECT LE_shortname FROM MT_guarantee_list WHERE REF='" & [Ref] & "'")

Edit: For some reason, the forum software wouldn't let me finish the above code. I need to insert a double quote + single quote + double quote just before the closing parens.

Edit2: Ah, never mind. It finally let me do it. Cheers!

Hi, I used your function and the code your suggested but still keep geeting the #name? error

 

[Minty]

Try it in a query first. Then use that as the basis for your form.

 

[theDBguy]

Hi, I used your function and the code your suggested but still keep geeting the #name? error

View attachment 89530

Hi. A #Name? error typically means there was a typo. Please double check the expression you used to check for misspellings and make sure you didn't name the module the same as the function. For example, I use modDBguy.

 

[Wozza]

Try it in a query first. Then use that as the basis for your form.

Yes, I got it to work in the query. I did need to put in the table name though for it to work. 'SimpleCSV("SELECT LE_shortname FROM MT_guarantee_list WHERE REF='" & [MTR_Proj_info].[Ref] & "'"). ow to try and get it working in the form. Thank you so much for your help