>I have got a field on a form called Client(Actually Department) which gets it's values from a ComboBox(Dropdown List, Incremental Search). The RowSourceType for Client is a table(Allocation_Numbers) with 44 records of 2 fields(Client, Client_Number) each.
>
>I want to:
>
>-A-
>Copy the second field(Client_Number) to a textbox(Client_Number) on the form when the user selects a Client.
>
>-B-
>Concatenate Client_Number with another field(Depot_Number) to form yet another field called Exp_Alloc_Number.
>
>Can anybody help?
>
>Petrus.
Combo props:
Rowsourcetype : Fields
Rowsource : Allocation_Numbers.client,clien_number
Controlsource : table.field
Boundcolumn : 2
Columncount : 2
Columnwidths : 100,0
Combo.interactivechange :
thisform.Exp_alloc_number.textbox.value = ;
padl(this.value,3,"0")+;
padl(table.depot_number,3,"0")
Cetin