I have a form with a combo box and I would like to open another form with only the records that match the selection in the combo box. What is the best way to do this?
Additional Info: I have a main table with all fields and then a 2nd table with the 16 different names that might appear in that field on the main form. From the 2nd table, I created the form with the combo box.