NotInList Pasting Multiple Records into one Combobox (1 Viewer)

[hubelea]

I am relatively new to Access, using 2007. I have a form with a subform, subform in datasheet view. I was successful in setting up NotInList so that when I add a record to the UPC combobox it will update the appropriate table if a new record.

However, I've set up the form in datasheet view specifically so that I could copy and paste (and/or append) large numbers of records from excel. The NotInList works when I manually add one record at a time, but not when I paste multiple.

I'm thinking there is an 'event' in there I need to set up, but after spending quite a bit of time I'm lost as to which one, and how to do that. Any help would be much appreciated? (and please understand that writing code, while not impossible, is not simple for me...)

 

[vbaInet]

It's a clipboard to Access thing so if you want to do that then you need to find a way of interfacing with the clipboard item. An API perhaps but since you're relatively new to Access this is very advanced.