How to use Combobox to search in all columns

[bgarbage]

Hello
I have a table with id productName and a codeName
example


id productName codeName
1 ProductOne myCode01

I have also a form with a combobox that shows me the productName and I can choose from my list
I would like also within the same combobox to be able to search by my codeName

So if I type ProductOne to get my result but also if I type myCode1 to get the same result

Thanks in advance

[ranman256]

Then you need 2 buttons.
1 to search the NAME, 1 for the code.

Depending on what you set your BOUND COLUMN to..
if bound col = 2 the code,
I would make a txt box to capure the unbound column NAME
txtName = cboCode.column(1)


clickng the btnByName would open the query that uses the txt box
clicking the btnByCode would open the query that uses the comboBox

[bgarbage]

Hello,
Thanks for your answer
My problem is that the combobox is used to enter extra values in another table and one of them is the productName but it would be nicer to be able to search by name and by code too
I don't want to have buttons on the form as the info are entered by rows on the comboxbox is only used to select the productName
Thanks

[June7]

Can't use one combobox. Could use two comboboxes.

[bgarbage]

Hello
I can't because of access limit or something else
It would be nice to type into one combobox either information of two (or more) different columns and get the result
Any ideas?
Thanks again

[June7]

What limit?

I use a combobox to select field to search. This then sets the RowSource of second combobox with values from the selected field.

[bgarbage]

Hello again
I want one combobox to be able to search fro both field columns (productName and productCode)
Is this possible?
Thanks

[June7]

Well, if the combobox Limit to List property is set to No then user can type whatever they want (AutoExpand will only work with the BoundColumn values).

Then query can have same filter parameter under multiple fields with OR operator.

[bgarbage]

Thanks, I will try this and let you know