Thank you for your explanation and then the fix. I spent a lot of time with this. I was familiar with requerying and have used it many times, but this one did not work. THe code that I used for getting this to work from one subform to another is here in case another might find it useful...