Thank you both for the help! I was able to create a dropdown that writes the value to the table via the combo box wizard tool. When I select the option from the dropdown, it now writes to the table. My only persistent issue is that the dropdown one level up in the hierarchy that determines what Classification choices I have does not update as I move from record to record. Hopefully I will be able to figure that one out, but if not I may create a new post for some help (unless I'm supposed to add it on to this thread). Not sure what is correct.
Code:
SELECT tblClassifications.ClassificationID, tblClassifications.ClassificationName, tblClassifications.ClassificationTypeID
FROM tblClassifications
WHERE (((tblClassifications.ClassificationTypeID)=[Forms]![frmNewMain]![Combo700]))
ORDER BY tblClassifications.ClassificationName;