I am a warehouse manager. I have a table named Receivers. Recievers being cable boxes. Each cable box has a unique serial number. I have columns called Serial, Tech. I have figured out how to add new recievers to my inventory. And place them in "warehouse" under the tech column. I also have technicians who check out recievers and need to know who has what. So I need a form that will find a unique serial number in the table and then update "warehouse" to a Unique tech ID so now that tech has that Reciever in his inventory. I am rather new at this so if you have questions about my question please ask.