Adding to table through combobox input

  • Thread starter Thread starter Studentneedshelp
  • Start date Start date
S

Studentneedshelp

I have a form in which I have a set of ID's which (lets say some are already
entered). These ID's are referenced to this combobox through the row source.
I am trying to figure out a method in which the user can use this combobox
to select current ID's, and insert a new ID into the table if it doesn't
already exist. The user would hit a command button to enter it into the
database (for the ID that doesnt exist), or select an already existing ID. I
have tried a few SQL lines and they don't work. Any suggestions?

Thanks
 
Back
Top