I have a form with two values. The first is a Parts Category and the second is the Parts Name. I have set it up so that when I choose a particular Parts Category in the first combobox it only shows me the Parts that are associated with it in the second combobox. I want to be able to add a new part in the form when it is not already in the list. So I created some vba code for a not in list event to add a new part that is not already in the list. But as every part needs a part category, the code needs to enter in a parts category id with the new part when I add one. What I want to do is add the new part with the parts category that is showing on the form in the first combobox. So if I want to add "chisel saw" as a part, I would go to the first combobox and choose the parts category "cutting tools". Then I would add chisel saw to the parts list. But every Part must have a Parts Category ID associated with it. So I need to add in the vba code where I update the parts field to update it with an associated parts category id. I can draw the category name from the form's first combo box but am having trouble drawing the category id associated with that name. I am trying to figure out the easiest and most efficient method I can determine the category id of the category showing so that I can add the new part with that category id. Any thoughts?