Query combobox unbound column

Does anyone know if it is possible to run an append query referencing a
column in a combobox. In otherwords, my combobox is bound to column 0 - ID
and column 1 is the name. I want to append it to another table as the name,
not ID?

Thanks in advance,

Bonnie

Typically you would create a hidden text box like:
Name: txtTheName
Control Source: =ComboBox.Column(n)
Visible: No

Then reference txtTheName in place of the unbound column.

Duane Hookom
MS Access MVP

"Bon" wrote in message

> Does anyone know if it is possible to run an append query referencing a
> column in a combobox. In otherwords, my combobox is bound to column 0 -
> ID
> and column 1 is the name. I want to append it to another table as the
> name,
> not ID?
>
> Thanks in advance,
>
> Bonnie