I am quite prepared to help, however I do not work to deadlines.
We as 'helpers' also get chastised if assisting when forum rules are not abided by, so far 'moderators' have not picked up your failure to enclose your code with code tags, I have already pre-empted this hoping you would correct this.
If you had conformed we would have been 3 or 4 days further on with all problems answered, as it is past my bedtime here in the UK I have only had a brief look, there is far too much to correct to give a workable solution.
You will note under my 'signature' I do not use 'rowsource' for data handling, I have noted that you have introduced it into your 'comboboxes' (despite 'others' views I have found it to be unstable and a source of errors if its interactions are not fully appreciated.) Please enclose all your code in all your posts with code tags as requested and we can move on.