A little info about my database: I would like a user to fill out a form and enter it as a record and the records must be completely searchable. One of my fields (TsuApps) on the form is a multi-value field. I like how multiple selections are entered into the field as a string with entries separated by commas (yes, I know this is bad database design, but for my purposes it'll be fine), but you can't search it (multi-values fields aren't subject to WHERE or HAVING clauses).
My approach: I have adapted a bit of code, where a button is clicked and it reads in the items selected, adds a comma between each entry, and is stored in a string. (or at least I think that's what I'm doing) I want the string to be passed into a table field (TsunamiApps) of the same record so it can be searchable. But whenever I do that, it says the string length is 0. What am I doing wrong?
Also, if anyone has suggestions about my approach or perhaps a different approach to take, I'm all ears. But go easy, I'm really new to access and I have no idea how to normalize tables so this seemed the easiest route.