I am having a problem that is probably simple to you all. I have a database that will be used to track complaints of customers. I am making a form that will store each complaint. The Database has 2 relevent tables: Device which sores the Device Name, Device Type, and Model Number. The Second table is called Complaint which stores all the information of the complaint. I am creating a form that will populate the Complaint database, but I want it to autofill the Model Number and Device type when a user enters the Device Name. How can I do this.. I will send you my database if you need to see it. Thanks

There are a number of ways you could do this. One would be to use DLookup to find the appropriate Model Number and Device Type. Another would be to have a query with the Names, Model Numbers and Device types. Base a Combo box on the query and and let the user select the Name form the Combo box and then use Me![ModelNumber] = Me![ComboBoxName].Column(x) and a similar statement for the Device Type. This would be in the After Update event of the Combo box. And the x in the column(x) would represent the column with the data you want. Remember that the column numbers start at 0.

HTH,
Jack

Thanks.. It Worked!!