Query combobox unbound column

B

Bon

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
 
D

Duane Hookom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003: populate combobox with CSV values from table column 1
combobox uses query - filter set by checkbox ? 3
Combobox display question 5
fill a field from a combobox 7
Filter on combobox problem 2
Search / Ctrl + F in a combobox? 3
trim in rowsource with Right(), forcing a String return value with $,Access 2007 4
Displaying two fields in combo box 8

Top