J
jackie
I know that several people have answered this questions, and I have tried
different techniques as a solution, but all have failed.
I have 2 unbound boxes on my form txtStartDate and txtEndDate. I have gone
into the query and entered:
between Forms![Myform]![TextStartDate] and [Form]![Mform]![TxtEndDate]
Someone suggested that I also enter the two lines in Tools>Quey>Parameter. I
tried adding a parameter and leaving it out using only the criteria above.
However, when I go to the form, it does not filter by date.
BTW, My form has two other boxes for "location" and "street adress". These
boxes work fine. They run macros, which run queries.
Would sorting a field in the query have any effect on the results. Thanks
for any help.
different techniques as a solution, but all have failed.
I have 2 unbound boxes on my form txtStartDate and txtEndDate. I have gone
into the query and entered:
between Forms![Myform]![TextStartDate] and [Form]![Mform]![TxtEndDate]
Someone suggested that I also enter the two lines in Tools>Quey>Parameter. I
tried adding a parameter and leaving it out using only the criteria above.
However, when I go to the form, it does not filter by date.
BTW, My form has two other boxes for "location" and "street adress". These
boxes work fine. They run macros, which run queries.
Would sorting a field in the query have any effect on the results. Thanks
for any help.