I’m writing a program by using MS Access VBA.

In this program I have textboxes that I fill them out and once I click on the button it inserts the values whic are in the textboxes to a table named “Programs”, but I have a lookup field that allows to select multvalues and I can’t add the values into the Program table

Private Sub btnAdd_Click()

CurrentDb.Execute "INSERT INTO Programs (Program_Name, Objectives, Targetted_Competency) VALUES ('" & Me.txtProgramName & " ', '" & Me.txtObjectives & " ', '" & Me.txtTargettedCompetency.Value & " ')"


Programs_subform.Form.Requery

End Sub