Forms - Append data from unbound combo boxes to seperate table

I have a form setup that has 5 combo boxes where a user will select one item from each combo box. Each combo box is from a differant table. Once this is done I want to be able to append or update the results into a new table I created. My problem is I don't know how to submit the data from the combo boxes to the new table. Can anyone help me with this?

Thanks

Why not bind the form with the ComboBoxes on it to the table you want to update?

I did bind the table to the form. I still don't know how the information in the combo boxes gets inserted into the table that I want. I added each field that is to be updated to the bottom of the form but they don't get appended to.

Just bind each ComboBox to the appropriate field.

Okay that I guess is my question. I am new to MS Access so I don't know how to bind the combo box to the field I want in the new table. Is this done in the properties for the field I want updated.

Go to the Data tab of the Properties sheet for the ComboBox and use the dropdown in the ControlSource to select the field to bind to.

Thanks for the help.

Is there a way to get the form to jump to a new record right from the start or do I have to manually do that each time I want to add a record from the combo boxes?

Glad I could help. As you can see, in many cases Access can do most of the work for you with bound forms.

If you set the DataEntry property on the Data tab of the property sheet for the FORM to YES, the form will only show you *new* records.

Glad to hear everything worked for you. It's why we're here.

I am trying to do something very similar to the forum I just read with the unbound forms writing to a table.

I have unbound combo boxes that are updating depending on what they have chosen from the first combo box. That is all working great but when they have selected everything from the combo boxes and typed their comments, I can't get the information to write back to the nonconformance table for reporting later. All combo boxes are using the tblktables to get the data.

My question is how do I get an unbound combo box to write to the table since using the bound boxes is not an option?