I am have created a basic Asset Database that allows me to enter and keep track of asset within the company,

I have designed a transfer Asset form that I would like to use to help me in transferring know asset's to know members of staff.

I have got the first bit to work, search for a asset and display the current assigned user. I have done this via a Combo box.

I now would like to have a second combo box which will allow me to search for all known staff members from the Employees table and then have this update the Asset Table with the new value.