Maybe I missed explaining but I have a autocomplete combo. So the whole logic hinges on a joined character field in the view. In the end the whole thing will be based in the iID as the connecting link, which is what I am replacing in the ReplaceID().
>You're replacing the id in KeyPress ??? Wouldn't just setting the controlsource be easier. Anyway if it's working it works :)
>Cetin
>
>>I did try it plain but though the cbo showed blank the id was written to it by my ReplaceID() which is called in the keypress(), maybe it is me but I was not able to shift the replaceid() call to lostfocus().
>>
>>>That's not what I meant. With Ctrl+0 you don't need to capture and replace with a NULL. Ctrl+0 does it. IOW no code needed (like Ctrl+T,Y in browse or Ctrl+A,C,V,X).
>>>Cetin
>>>