I added a criteria to a query design field that looks like:
Between [Forms]![frmFormName]![txtStartDate] and [Forms]![frmFormName]![txtEndDate]
The field I added it to was from a table named G which I am assuming is a temporary table or query or an alias or something. Then I ran the query and the results were what I expected them to be so I closed the query. When I re-opened it the criteria was gone but the functionality is still there. In other words when I open the form, frmFormName and enter the two dates the query returns what I expect but the criteria is not showing.
What is going on?