how to show field from access in comboBox

your code will populate combo box rite.

but you've to write code when user select value in combo box it should be inserted into new table.

something like this shall work for you:

da.newRow(combo1.value);
da.insert();

i may be wrong syntactically but algorithm is right

tanks to answer ...
this code is OK


DataTable table = new DataTable();
                string sql = "Select New from Album";
                con.Open();
                OleDbDataAdapter da = new OleDbDataAdapter(sql, con);
                da.Fill(table);
                table.Rows.Add(" ");
                comboBox1.DataSource = table;
                comboBox1.DisplayMember = "New";
                comboBox1.ValueMember = "New";
                comboBox1.SelectedValue = " ";

insert into tableB (id, name) select id, name from table 1