Combo Box Value into multiple tables

[brobertson89]

I have created a combo box in a form that works off a query using another table (we will call table 2). The form was created using table 1 so now the values in this combobox do not store into the column in table 1, how do I make this happen?

[June7]

Set the combobox ControlSource property to the field you want to save data into.

[brobertson89]

Thank you again June7!

So I have that working but now because there is two columns (ID and the actually description) and I only want to store the description how do I do this? because at the moment it is storing the ID

[June7]

If you are just referencing the table as RowSource, options are to delete the ID field from the table (if you don't use it anywhere it is unnecessary) or move the ID field so it is below the description field in table design or set the combobox BoundColumn property to 2.

Or use an SQL statement in the RowSource to exclude the ID field: SELECT [description] FROM tablename;