Dear All,

I am using the following Sql statement to insert rows from Table1 into Table2:
(INSERT INTO AN_EmpUR (SysID, Frm_NameSys, Frm_NameText, Frm_Item) " & _
"SELECT SysID, Frm_NameSys, Frm_NameText, Frm_Item FROM AN_SysURM")

This works fine, but the problem I need to add to that statement another filed with a value from a combobox in the form.

Is there a way to do that?

Thanks for the help