Access 2000 doesn't search the text in a Combo Box?

[Aaron E via AccessMonster.com]

Hi All,

I have a combo box that stores a ClientID, but displays the ClientName, as in
the following excerpt from the properties window:

ControlSource:...................... fkClientID
Input Mask..............................
Row Source Type.................Table/Query
RowSource............................SELECT pkClientID, ClientName FROM
tbl_Clients
Bound Column......................1
Column Count.......................2
Column Heads..................... No
Column Widths..................... 0";2"

the underlying table is pretty basic, some sample data looks like this:

pkClientID ClientName
1 AAA
2 Academy of Art College
3 Allstate

So I assume this is a pretty basic way to rig up a combo box, right? I have
a few reasons to want to store the ClientID in there instead of the
ClientName.

Anyway, the problem is that Access 2000 won't search the text of the combo
box, while Access 2002 will.

So if I put my cursor inside the combobox and press ctrl-F on the keyboard,
and type in "AAA", Access 2000 won't find the first record, while Access 2002
will find it.

Anyone ever hear of this problem before, or know a workaround for it?

Thanks.

Aaron