Uhhhh, sorry. I was continuing my previous thought on adding data. Sorry, I should have specified. I created a separate form to do the data entry in because that's more intuitive for the end user, IMO.
So this block of code is only for adding data to the tblCollection, tblDesignName and...