[RESOLVED] Can I use a pop-up window to add info to a db table?

[osemollie]

I have a combobox that displays names of movie actors from the actor table in a DB. I have the following code:-

Private Sub cmdAdd_Click()
 
    Dim strNewItem As String
    strNewItem = InputBox(prompt:="Enter Actor's name")
    cboAddActor.AddItem strNewItem
   
End Sub

Which adds an actor's name into a combobox. But I wish to know whether as the name is added into the combobox, I can get it added into the the database too, using INSERT code.

Thanks

[Al42]

Private Sub cmdAdd_Click()
 
    Dim strNewItem As String, strSQL As String
    strNewItem = InputBox(prompt:="Enter Actor's name")
    cboAddActor.AddItem strNewItem
    strSQL = "Insert into actortable ([Name])  Values('" & strNewItem & "')"
    YourConnection.Execute strSQL
   
End Sub