i have a form with a subform that is in a datasheet view. what i would like to do is have a subform from my subform. BUT i don't want this in datasheet view. what i want to do is when i select the record in the first subform, the second subform will change so that it relates to the first one. can someone help me with this? thanks.