[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