How to have 3 search in a combo box

[richardplr]

Hi

I have a combo box for search of text, but I have 3 columns on the combo box,

How to do inorder that I can search for the desire information I want. such as I can type person name (in charge) or product description or date check.

I have attached my program for your info,

Please help

 

[Ally]

I'm not 100% sure exactly what you need because at the moment there's hardly any data in your Checkdate and InCharge fields but if you wanted to search by eg InCharge, you need to change the field order in your combo box.

-Go to design view of the form.
-Click on the combo box and open properties box.
-In RowSource click on the ellipsis (...) This will take you to the query builder
-Select the InCharge 'column' by placing your cursor at the top of the column so you have an arrow pointing down and then click
-Click again and hold, and drag it to the first column

This will make it the first column visible when you click your drop down box.

Hope this is what you needed.

 

[richardplr]

I'm not 100% sure exactly what you need because at the moment there's hardly any data in your Checkdate and InCharge fields but if you wanted to search by eg InCharge, you need to change the field order in your combo box.

-Go to design view of the form.
-Click on the combo box and open properties box.
-In RowSource click on the ellipsis (...) This will take you to the query builder
-Select the InCharge 'column' by placing your cursor at the top of the column so you have an arrow pointing down and then click
-Click again and hold, and drag it to the first column

This will make it the first column visible when you click your drop down box.

Hope this is what you needed.

This is incompleted table. so you hardly see too many data (Sorry about that).

My purpose is that I have 3 choice to choose for search data, if I want to use the way you describe, I think it is too trouble. (I can create 3 combo box in that way, right???)

Thank you for your contribution.

 

[Ally]

Yes you could probably do 3 combo boxes. You'd need to do a similar thing with moving the columns around so that your desired field was visible in the first column, or not having them visible at all. You would also probably need three "Add" buttons to add it to your subform, as that's what I presume you want to do.

 

[Parker]

Or have a look at this.