i need to do a record search in a form but there are a few twists. 1. this form is (by itself) simple and used for creating totally new records and entering them into a simple table (all fields are text, date or number) 2. there is no unique field to any of these records 3. the form has 9 fields, 5 of which are required for creating a record. 4. the solution has to be super easy for the end-users of this database. i'm thinking of a command button that pops up a form that let's a person select up to 3 criteria (2 of which are one of the required fields mentioned earlier and 1 is not -- but i don't want to require any of them for this search so i need to allow for null values in the ones that they don't pick) and then searching the table for all records that match those criteria. then letting the user select which record they want to edit (i would need to know how to let a user select a record), then closing the popups and displaying the record in the original form, ready for editing. i can do the button to pop the 2nd form and the controls for that form (probably 2 text boxes and 1 combo box, if that matters) but dont' know how to DO the search, return another popup of results, select 1 and populate the 1st form.