>>>>>Hi,
>>>>>
>>>>>I don't know if I'm missing something, but I have a ComboBox where the user can choose a "Client" in a form that handles "Instructions from Clients". When the drop-down list is open the user must see "Client's NickName", "Client's Name", "Client's Country" and "Client's City". So I have a ComboBox with 5 columns (the last one, that is hidden, contains "Client's identification") with a RowSource based on v_Clients. Everything is fine, but when the drop-down list is closed, the user can only see the TextBox with the "Client's NickName" (first column) and I have a need to see all 4 fields.
>>>>>I created 3 TextBoxes bound to "Client's Name", "Client's Country" and "Client's City" and everything is fine. The problem happens when I need to add a new "Instruction" and the 3 new TextBox are filled (with the first record of v_Clients), although the ComboBox is empty.
>>>>>I know that I could suggest a "default" client, but it doesn't make any sense, sice there are more than 10.000 client's in the database..
>>>>>
>>>>>Any tips would be great.
>>>>>
>>>>>Regards,
>>>>Jose,
>>>>You could use just two columns, one for id (hidden) and the other bound one is a concatanated info NickName+Name+Country+City.
>>>>Cetin
>>>
>>>Or a grid maybe?
>>>
>>>Nick
>>
>>Could not understand, Nick. What do you mean, call a form with a grid from a command buttom, select a client and fill a textbox with all the fields I want ?
>>
>>Regards,
>
>Yeah, that's what I mean, small lookup form with read-only grid instead of combo. If it is appropriate in your case, of course.

Thanks Nick, I'll think about it.