Double filter in combo box

[Dragon]

Hello,

I have the table with two fields. First field is ProductID and second is
ProductName.

ProductID ProductName
0000001 CPU CELERON 2600 MHz
0000002 CPU CELERON 2400 MHz
0001000 MB ASUS PRO
0001001 MB ASUS DELUXE
0002000 MOUSE LOGITECH OPTICAL XXX
0002001 MOUSE MICROSOFT OPTICAL XXX
etc.

When I click in combo box and I write for example 0001000 or MB ASUS PRO
(same think) I must to get MB ASUS PRO.

How to make double choise in combo box - with ProductID and ProductName in
same time?

Thanks.

 

[Douglas J. Steele]

While only one column in the combobox can be bound to a specific field, you
can access the other columns through code. For instance, assuming your combo
box is named cboMyCombo, Me.cboMyCombo.Column(0) refers to the first column
of the selected item, Me.cboMyCombo.Column(1) to the second column and so
on.