>>>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,