Combo Box Multiple Columns

[spongie1]

Here is what I want:

1. To SELECT 3 columns FROM a query ORDER BY column 3 ASC.
I want to display the second and 3rd columns in dropdown and the non-dropdown area of the combo box.

2. I want to start typing data from column 2 and have it automatically select the correct entry from the dropdown list.

3. I want it to display both columns 2 and 3 in the non-dropdown portion of the combobox.

4. Finally, I want to save the data from column 3 in a table.

Here is what I have:

1,2,4

Currrently, I cannot get 3 to work properly. I can display the values in column 2 in the non-dropdown portion of the combobox, but I cannot display both columns 2 and 3 at the same time even though it diplays both in the dropdown.

Is there any way that I can make this happen?

I am sooo close.

Thanks,

Jason

 

[Moxy1]

This might help:

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=4284

 

[spongie1]

At first I was angry by this faq reference because the information the faq provided implied that I really wanted to do was not possible in the way which I wanted to do it.

I had a little trouble referencing the combobox properly in datasheet view as a member of a subform. Here is the code I put into the control of the textbox:

=[Forms].[frmMachineDT].[frmDTEntry].[Controls].[Item]("dtEntryDescription&quot.[Column](2)

Where frmMachineDT is the main form
frmDTEntry is the subform
dtEntryDescription is the combobox
Column(2) contains the downtime description

Thanks for your help... have a star for saving me time pursuing a nonexistent feature