2nd of 2 cascading combo boxes saves incorrectly to underlying table

[robin a]

I have read through your cascading combobox postings and I can't find this solution: I have 2 cascading comboboxes in a form. they work nicely in the form and when I click save the info saves to the table I have set in the form properties. Problem is, everything saves fine except for the choice in the 2nd combobox. I saves a random choice from the list instead of what I choose. I am using two tables that are joined by the CategoryID and SkillID fields. The fields being saved are the Category and Skill fields. The category combobox is the first one and the skills combobox is the second (not saving correctly). I have attached the database (it's small I've just started it). the form is Input_frm and the table recording the data is data_tbl

[NeoPa]

I can't look at your database as it's an ACCDB. See Attach Database (or other work) for a way to handle that reliably.

In your position I'd look closely at the design of the ComboBox itself. Maybe even use Debug (Debugging in VBA) and determine the .Value property before it saves away.