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.