I have a form that is strictly used as a result of a look up query. The problem is that I do not want the combo boxes to show as combo boxes on the form. I want them to show as text boxes. I created an unbound text field and made the control source.......cbocombobox.coulumn2 but this is not working. I am just getting a #name error in the unbound field. Any help would be greatly appreciated.

The proper syntax is:
cbocombobox.column(2)
Keep in mind that the combobox index starts with 0. So:
cbocombobox.column(0) = the first column
cbocombobox.column(2) = the third column

As usual.....thanks Pat.

Is there a way that I can still obtain the column information without the combo box actually physically on the form?

It can be on any open form. Just extend the reference to it a bit further ie:

=[Forms]![frmAnyOpenForm].[ComboBox].[Column](2)

Thanks that worked.

BAC