I have two tables, one Switch table(Table Name dbo_DTS_Switch) that holds all the Switch ports I have(field Name SwitchPort), the second table (Table Name dbo_DTS_Server) holds two fields that contain the switch ports(Field Names Switchport1 and Switchport2) that have been used. What would be the code to compare the one total list to the two used lists and display them in a combobox(SwitchPort) on a form? I really love this site and you all are alot of help. Thanks for any answers and help I can get. Hope you have a wonderful weekend.