Combobox help

[PRodgers4284]

I have a form that includes to comboboxs populated form two table, the second combobox changes values depending on what has been selected from the first combobox, this is working fine. The problem im having is when i try to add a textbox and save the records, the records save by the textbox value is on a separate row in the table from the combobox values. Can anyone help?

My database is below:

 

[boblarson]

Just bind the form to the table (actually a query is preferable) and get rid of the code to insert. You are saving one record and inserting another via code.