>Thanks for understanding. First things first, I have seem <g> and <bg> what is <s>, smile or a sigh <g>.
>
>< lol >!!!! If it were a sigh, I would not be very understanding, would I ;-)

I get it <bg>.


>

>This.nOldDblClick = _dblClick
>_dblClick = 1.5
>

>
>and code like this in the LostFocus()
>

>_dblClick = This.nOldDblClick
>

will do.

>Yes, I have my own auto-complete combo box class. It works just like that. My point is that you do not need to write any code to update the combo's ControlSource with the foreign key value in the combo's RowSource. All you need to do is to set the Combo's BoundColumn to the column number of the RowSource that contains the foreign key and set BoundTo to true (since it is an integer).

Agreed and if such a cbo does also this, well that is just what the doctor ordered. I have problems if I forget to populate the ReplaceID() function, this is just it. Thanks a lot, wil the KeyPress() you shared with me be the ticket? or is there more codes required for such a auto-complete combo box class