combo box and column selection

[bill crumpton]

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.

 

[bill crumpton]

As usual.....thanks Pat.

 

[bill crumpton]

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

 

[Shep]

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

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

 

[bill crumpton]

Thanks that worked.

BAC