combo box

[deepucec9]

Created a new combo box (unbound) with 3 columns "ponumbe/productid/quantity", it autofills other fields on selection.
There are duplicate entries in combo box eg: same ponumber and different productid


PO Number Product id
45000123 10001
45000123 10002

combo box displays ponumber in ascending order, system always select the first ponumber, not able to select the 2nd ponumber with productid 10002

TIA

[NTC]

the property of the combobox must be set to bind to the unique ID, rather than PO Number which is not unique

[deepucec9]

Im using combo box to select different product from the database, same product has different PO Number and vice versa.
So I cant bind it to unique id.
Any other workaround solution

[NTC]

yes you can bind it to the unique ID ... that bind should not cause any issue

[deepucec9]

I would like to type in the product number in the combo box for selection. If I bind to unique id for selection in my case it is ID (autonumber), i wont be able to type in and search the product from the list.
There are products with same product number but different PO Number/Invoice number etc.

[Ternick]

If you bind it to the ID number you can still have it list by PO/product. the ID is in the combo box, just not visible so instead of setting it to match from col 1 or 2 use col 0. I have to do this alot myself as I can have the same PO with different Service providers or Employees with the same first name

[deepucec9]

Tried creating a combo box with the unique id (ID), now I can select any records.
But if the list has 100 products and user knows only the product number, he has to scroll down and look for the match, cant type in the code and search.
combo box accepts ID number only, is that right?

[Ternick]

Set the combo box so the columns are (0,x,x) where the x is how big you want that section to be. This will hide the id from the drop down list but will allow you to use it still. Should beable to search like before with the id "hidden"

[deepucec9]

But the user dont know the id value for each product, they know only product number or PO Number.
In that case user can enter only the id value in the combo box right?

[Ternick]

Not that I can See on my forms. Make a copy of the form, edit it as needed and test it out. If it doesn't work then you won't have to undo to keep the program the way it was

[deepucec9]

Tried the above
Its working fine when the fields in combo are from a table, here the fields are from a query, so not able to hide the ID field also

[Ternick]

Ill play around with a database i have tonight and let you know what i figure out

[deepucec9]

Thank you

[Ternick]

Sorry was very busy yesterday. I tested it out and if you set to be bound to the id, sorted by the PO. Go to the box properties and change the first number in the column width to 0" It will hide it and allow you to search like you want. If it still doesn't work could you please upload the form and related tables and query.

[deepucec9]

You are correct, its working fine now.
thank you