Does anyone know if it is possible to paste data into a combobox? Imagine a datasheet form that has a column that utilizes a combo box. The combo box validates the entry against a table/query. Ideally, if you add a record you should select from a dropdown list of a combobox. My issue is that each time i enter data i have to enter couple thousand records (think accounting entries). I would like the combobox to just take what i am pasting when i paste these entries en masse as long as it passes the validation test.

Alternative solutions to just getting this data into the table (with validation) are welcomed as well.