My form has a subform. My sub form is in datasheet view and list many records. My main form has just one record. When I click on one of the records from the subform, I would like the main form to refresh, and show a new record, based on a value from the record I just clicked on from the sub form. PLEASE HELP!! Thanks