Searching in a Lookup Combo

[tinker]

Hiya.

On my main form i have several combo boxes, all of which use Lookups

Everything appears to work fine until i use access 2k s inbuilt find facility to find an occurance in a certain field. For example if i do a search in the Country field for Great britain it wont find it even though i know theres records in there with Great Britain as the country. But if i search for Great Britains ID (which is 128) it will find it, even though the text displayed in the combo is Great Britain.


Is it not possible to use access 2ks in built find facility when using combos which use lookups.

If not can anybody suggest a way of finding particular words within a field within a combo box that uses a lookup

Cheers

 

[FoFa]

The Combobox is bound to a field in the table. When you search it uses the Bound field as the target of the search. If this bound column does not contain Great Britian, but rather 128, than it would not find it.

 

[tinker]

Thanks for your reply

Although it is bound to the ID field, because it has a lookup set up bringing back a narritive i assumed it would find i narritive value aswell, looks like i was wrong

In that case is there any other way of searching for a narritive in the combo boxes which are number fields (with lookups to a narritive)


Thanks again