Issues saving from Form to the Table

Good afternoon all.

Please bare with me, i am new to access and may ask a few too many questions over the coming weeks.

I am having issues with saving a form to table "Tbl_New_Component"

So far in the build i have 3 tables
Tbl_Asset_Type
Tbl_Category
Tbl_Components


They correspond with the appropriate custom userforms
Frm_New_Asset_Type
Frm_New_Category
Frm_New_Component


Some people may ask why i have forms instead of entering the basic info into the table directly.... This is going to be a system in its completed stage where there will be people not knowing a single thing about access that will be using it, Eventually it will be set up as a dashboard and no access knowledge will be required.

The issue being had is that when i save the input into the "Frm_New_Component" it comes up with an error, If i go to the code and comment the line with error out, it then saves everything except for the combobox causing the problem.

I suspect this is an issue with the primary key, and collecting information from another table without reference to the primary key. However, I do not know how to rectify the problem i have. Can you please send me in the right direction.

I have reduced to database to its bare bones and then zipped it just to allow me to upload. Fingers crossed this will be enough for you to see what i am having issues with.

Ive also posted this into Access forum and awaiting result there https://www.accessforums.net/showthread.php?t=88481

Thanks in advance CMMS - Copy.zip