It's been a good long while since I've needed to make a form on Access again. I have a simple form - subquery/subform to be queried by a simple date range. When I switch to form view, my query runs immediately without having to enter a date range and choose run - even though I have my query dates setup asandCode:Forms![MyForm]![datefrom]. I've done a ton of research, but found nothing relative to my situation. I have old forms that I've gone back to to see what I am doing wrong, but it's setup basically the way my old forms were so I don't know how to keep my subform/subquery from running immediately after choosing form view. Also, upon switching to form view, it doesn't even register that there are no dates to be queried even though the form dates are blank and the query is set to the Form![MyForm]![datefrom/to] redirect.Code:Forms![MyForm]![dateto]