Greetings!
I designed a form for a colleague using a listbox where the user can enter their contact information and then use the listbox to select what they are interested in out of 30 options. The new record then populates a master table, with one column indicating the selections as a string with VBA code.
They really like what I've done, but instead of a listbox, they want check boxes next to each of the 30 options for the user to indicate interest. I created a second table with 31 columns to join with the master table of user information, each user having a unique ID and using that number as the join key.
Access really doesn't like this idea, so I tried to "unbound" each check box, but now I am wondering how to link them all back up again and insert into the proper table with the proper user ID number. Any thoughts???
Thanks a million!!
(Also, I'm using Access 2016)