***************************
From the Private messaging
***************************
>Nick -
>
>I put your code in my combobox (I used an insert into instead of append blank but otherwise the same), and for the first time it works! So, I wanted to thank you for that.
>
>But I do have a few questions based on other things I tried and something Cetin said (I still want to try that code):
>
>First, why did you choose Valid instead of LostFocus event as some others seem to recommend?
You can use it in LostFocus. In my case the reason was that I wanted code to fire without leaving my combobox control also.
>Also, I left my rowsource type as fields, whereas you have yours as Alias, but now mine seems to be working, so don't know what the difference would be.
No specific reasons, my combo I copied the code from had a RowSourceType = 1 (Value) :)
>I don't have any buffering in place for my Cities table right now, so don't know how Cetin's comment about that would impact.
If you have buffering enabled then you will need to use TABLEUPDATE() somewhere also.
>Even though this seems to be working, I still don't feel I have a good handle on the process, and want to understand the connections between these factors (i.e. why one thing works and another doesn't).
>
>If you want to answer in the public forum to both Cetin and me (so as not to repeat), that's fine. I just wanted to thank you for taking the trouble to email me your code.
>
>Sylvia
Well, Combobox and Grid are the most complicated and tricky controls in VFP, some workarounds we do for them should be just their native functions...
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison