>>>>>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
Dorris,
I would than create the cursor with myTable.myFIield and would also use the cursor as controlsource for the combo
Find attached a zip-file with a working form, try it with my name Koen Piller and retry it with your name
I am listed 2x in the Officer.dbf so the combo filles with 2 reccords, you are listed only 1time and therefore not listed.
Is that what you are looking for?
Regards,
Koen