I have a subform in datasheet view. When I change one field I want to requery another field to show only data that relates. This works but if I go to the next record in the datasheet and it performs a requery the it erase my previous field. How to I get it so the requery only performs in the record I'm working on.