>
I am comparitively a starter, definately not advanced, in VFP so please bear with me.>
>No problem < s >. We all start at the beginning.
Thanks for understanding. First things first, I have seem <g> and <bg> what is <s>, smile or a sigh <g>.
>Now I am sorry about being so slow because I still do not understand what it is you are trying to accomplish here.
Don't be I am the one who is complicating things. Actually I am using a borrowed cbo, so the code that it originally provided I thought was ultimate.
>I thought that your combo had a list of descriptions and their associated key values and that you needed to replace the foreign key in the combo's ControlSource with the PK of the entry in the combo. Is this not so?
Exactly
>If this is the case, you do not need any extra code to update the combo's controlSource.
But in such situations I had always seen cbo which are more like collapsed listboxes, the text displaying there is always readonly. You can type in it and the values do change but depends on the speed of the users typing, if he slows the cbo start search from the next character he types which can be frustrating to slow typers.
This combo of mine allows the user to type into the cbo as if it is a textbox, highlights the characters following the chars typed by the user, matching to the closest possible record in the lookup. Backspace and the selection goes back to earlier matches.
Hope I have been able to clarify my requierment.