Inserting ComboBox selection into Access DB

[jeff]

I have a form that displays a combobox, where the selections come from a
single table and I want the abilility to insert that selection into a table
in the same database when the choice is made. Row Source is a simple SQL
statement and I currently have no Control Source (All attempts to add one
using the expression builder have failed. <[email protected]>

 

[Alex Dybenko]

you can use combobox afterupdate event to run append query (docmd.openquery)
to insert selected value in a table.