How to create a search drop down that has 2 columns and want to search on the unbound

[annarene]

Hello: I'm working in Access 2010. I have a simple form that is bound to table "Jobs" in which the key field is job number.

I want to create a search drop down. I need it to display both the job number and the customer name; and I would like the user to be able to start typing the customer name in the dropdown and for the drop down to pull it up as I'm typing it.



I create a simple query for the row source of my drop down:

SELECT Jobs.Job_Number, Customers.Customer_Name
FROM Jobs LEFT JOIN Customers ON Jobs.Job_Number = Customers.Job_Number;

When I run the query, I get both columns.

I set the bound column to 1.
Column count = 2.
Column widths =1";1"

Go to run it and it displays only the job number in the drop down after I select. In addition, it does not filter at all.
can you please guide me in the right dirrection? Any help is truly appreciated.

Thanks,
Proctor

[ssanfu]

Maybe this will help you:

http://allenbrowne.com/ser-03.html

[annarene]

yes, that did help quite alot! Thank you for sending me this.

Proctor