Combobox on a form

[Bill Pugh]

Hi:

I’m having problems with a combobox on my form:

I have a form called Orders. On this form I have a Combobox called Order Selection Box. My combobox pulls in from a query two lines (Orders and part no). Under my combobox I have a text field that shows the part no from the combobox. Problem is… I have to use the bound column to get the part number to display in this text field. I have a query that I need to use the
[Forms]![Orders]![Order Selection Box] to pull in just the order on the form. Access doesn’t see this due to the bound column to the part number. I hope this makes sense. This is making me crazy.

Thanks

 

[dcx693]

You can reference any column in a combo box (or listbox) by using the .Column property.

To get to the first column:
[Forms]![Orders]![Order Selection Box].Column(0)