One filter for 3 Queries in Union Query

I currently have a union query with 3 queries linked to it. There is a “Start’ and “End” date filter for all three queries. The start and end date filters pop up three times(One for each query). I am trying to only get it to pop up once but to apply the filter to all three queries in the Query Union.

Thanks. I am fairly new to access so I might need a little additional help. So far, I created a form named DateFilter with two text boxes and named one dtStart and the other dtEnd. I then a where statement in each of the three queries under the date that is to be filtered. Should I create some kind of button in the form to execute the UNION query? Also is my where statement correct?

"WHERE StartDate"="mm/dd/yyyy" & [Forms]![DateFilter].[dtStart] & "mm/dd/yyyy" And "EndDate"="mm/dd/yyyy" & [Forms]![DateFilter].[dtEnd] & "#"

Thanks for the clarification. I just entered this inthe criteria of the Date field:

Between [StartDate] And [EndDate] WHERE StartDate = #" & Forms!DateFilter.dtStart & "# AND EndDate = #" & Forms!DateFilter.dtEnd & "#"

But it said there is an invalid syntax. I am trying to figure out what the error is. Thanks for your help

I am doing them in the source queries. Is this correct?

I am using query design view. Is this correct

Thanks. I think my problem is that I only a DATE field. how could I break this down into start and end date and then point to the form? I think I might have missed a step. Thanks for the help.

that generates the query but it also displays a pop up for start and end 3 times(one for each query) I have the following in the date field criteria for all the queries

Between [Forms]![DateFilter].[dtStart] And [Forms]![DateFilter].[dtEnd]

Any ideas what might be causing the problem?

Thanks

yes the form is open and i created a button to run the UNION Query. Any ideas what the problem might be?

Thanks

This the UNION sql code. I have a command button on the form to generate this UNION query

select * from application_final
UNION
select * from locked_final
UNION select * from funded_final;

Thanks

how would i get to source query? Thanks

i figured it out, the query parameters were set to START and END. I removed them and it generates perfectly. thanks for all your help,