pop up date picker?

[YouMust]

Hi all,

I have a query and when its run I have a pop up asking for the date required. however, I cant get it to filter on that date. it asks for it, but fails to filter on it.

This is what i have for the criteria
<DateAdd("m",1,DateValue([enter mm/yyyy]))

the date format of the field is
19/03/2018 13:43:05

I just simply want to filter by month, so a date of 08/2018 would be entered

 

[arnelgp]

Add another Startdate in your query but dont Show. Format it as "mm/yyyy".
Add criteria to it: [enter mm/yyyy].

Yiu must fill the parameter as yiu declare it, meaning months less than 10 will have leading 0 and year must be entered in 4 digit.

 

[YouMust]

Add another Startdate in your query but dont Show. Format it as "mm/yyyy".
Add criteria to it: [enter mm/yyyy].

Yiu must fill the parameter as yiu declare it, meaning months less than 10 will have leading 0 and year must be entered in 4 digit.

Thanks for your help arnelgp

applying this gives no results, unfortunately.

 

[YouMust]

I've exported to a clean database.

So you can see it in action

https://drive.google.com/file/d/1twd9tPXNur6BCbADjoSOKq85ShUHglfK/view?usp=sharing

 

[YouMust]

Ok I got it,

Like "*" & [enter mm/yyyy] & "*"

Thank you arnelgp as always, a great help!

 

[YouMust]

There is just one problem, when I marry this with a form.
i get an additional pop-up asking 'tblTestResults.StartDate'
If I just click ok it loads the page/data fine, any way to remove that pop-up?
It doesn't happen if I run the qry manually, just with a form

 

[arnelgp]

How did you marry them?

 

[YouMust]

Thanks again arnelgp!

That was my mistake I used an old form, creating a new form from the qry resolved the issue