Thx, that is a reasonable suggestion and the problem is easy to replicate. For now, I moved the recordsource setting/refresh behind a button on the main form. So user must enter/select date then press button instead of just tabbing out of the textbox. I just thought someone else might have...