Combo Box Suggtions

[Gordzilla]

I have a form where the user needs to select from an existing list of Parts.
There are 2 combo boxes on my form. Both return the Primary key from a main
Parts table. One combo box allows the user to select by Part No. the other
by Description. Both combo boxes have the same control source.
Anything wrong with this methodology.
Better way of doing it?

Gordzilla

 

[Golfinray]

Just for gp, you might check Allen Browne's site at www.allenbrowne.com. He
has some good info on combo boxes.