Multiple options to find criteria

[sandiman]

I'm building a database with supplier information. Some users prefer to use the supplier names, but it is sometimes hard know how foreign suppliers are spelled, therefore some users prefer to use supplier numbers.

I want my form to show all supplier data based on either the supplier number or the supplier name, which can both be chosen from 2 comboboxes.

In addition, and here's the catch, I would also like the two comboboxes to update eachother. So if I choose supplier 2 in the first box, the other box should automatically show me the name of vendor 2 and vice versa.

I think the example form shows my problem best ..

 

[carash77ash]

Why not do one combo box that shows both fields. Create an sql query that lists both rows in the combo box.

eg: select distinctrow table.supplier id, table.suppliername from table order by suppliername

then in the properties box set the format property coloumns to two. Or you could create the combo by wizard. It would howver only be bound to one field.

Hope this helps

Ash

 

[sandiman]

That works, but doesn't really solve my problem. I tried it with the wizzard by the way.

I would like the names list sorted alphabetically and number list sorted ascending. So I really need two separate combobex that update eachother.

Maybe there's a simple line of vba I'm missing?

 

[sandiman]

Still need help on this one

 

[clerics]

Is this what you're going to do ?
I did it just like what i think you need, but it would be better if you used only 1 Combo !

Good luck friend !