Adding to table through combobox input

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronized Comboboxes 1
Open form to ID and add in the record if not there 0
Unbound combobox invalid datatype error 6
Unbound combobox generating data type error 0
Coding Afterupdate of Combobox to modify data shown in Textbox 5
textbox and combobox 3
Replacing "null" with "(default") in a combobox 4
reference table and where condition 1

Top