- Local time
- Today, 04:43
- Jul 24, 2020
I don't need to see the word "duet". I want to se who the two artists or more who sings the song.Whenever you have "many" of something, you need a subform. Use a subform to show the artists rather than a single combo. The artist field in the subform will be the combo you now have on the main form.
If you really need to see the word "duet", use a dcount() on the artists for the song. If the number is 2, it is a duet, 3 a quartet, etc.
I've tried using dcount() with the name of the song in the function but there are more song with the same name so dcount() didn't work.