>>>>I said using == operator:
>>>>
>>>>
>>>>local id
>>>>Id = "BONAP"
>>>>Id = "BONAP "
>>>>
>>>>Select * from _samples + 'data\Customer' ;
>>>>where Cust_id == m.Id
>>>>
>>>>Id = "BON"
>>>>
>>>>
>>>>
>>>>Either field cust_id or m.id might have as many as trailing spaces you wish. During select trailing spaces would be automatically removed for comparison (also check SET ANSI).
>>>
>>>Yes, and that's because the string you search for is longer that the field value, and every character match up to the length of the field. Try ID = "B ".
>>>
>>>BTW I have Set Ansi Off, which makes a big difference.
>>>
>>>NB! Let's leave it, I'm going to bed.
>>
>>OK :) But you seem to be unaware that == behaves like an implicit SET ANSI ON.
>
>Cetin,
>according to the published code by Dorrin, the Rowsource is:
>
> .RowSource = "Countit.lastname, firstname, DOB, empcnty"
>
>where the fields firstname, DOB and empcnty are from Officer.dbf. Can one combine two datasources in one combobox row in that way???
>
>Koen
The fields are first pulled into the cursor Countit from the Officer.dbf
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place