I have a main form, inventory, with its accompaning table. I have a second table, peripherals, which list the other equipment. The primary key in the main table is the inventory asset number which I have joined to a field in the peripherals table called location, which is the asset number of the invetory the peripheral is connected to. On the main form is a cmdbutton that displays any peripherals connected to a computer. Of course, if I select the cmdbutton and no peripherals are connected to that user then it displays a blank peripheral form. With all that said, what I would like to do is to disable the cmdbutton unless the computer does have peripherals attached. To do that I know I have to compare location number in the 2nd table to the inventory asset number displayed on the form (from the main table)and if the same number is located then enable the cmdbutton. I am stuck on this... thanks in advance.