I am creating a data entry form to answer a questionare. the question id and question are on the master form while the answer (combobox with true, false, n/a) comments (textbox) location (multi select list box with source from another table) and year (textbox)
i need help with 2 things
1. I would like the code for to make new entries in the table for each option selected in a multi-select box that keeps all the answers in the other fields on the form.(I dont know VBA myself so any help in that area is helpful)
2. if possible, a button that would create the new entries and then clear the subform for more data entry without going to the next question.
Again, i dont know any VBA myself so i would need the code to either be given or linked to me. Im new to access and i appologize for any misinturpretations or incorrect names for things.