I am creating a Access database that keeps tracks of our tools. I have created the table that has all of the current tools in it. Built on top of that table I have a form that allows the user to add a new tool, delete an old tool or check out a tool to a technician. The problem is that to find a particular tool you have to go record by record until you find the tool that you want. I thought that it would be easy to create a combo box that would list all the tools in the table and by selecting that particular tool it would change to that record so you could check it out, check it in, or what ever. I have the combo box created but when you select the description it changes the description of the current record. Any ideas on how I can accomplish this task?
Thank you in advance.