How to make a Request from a Form in Access?

Question

Microsoft Access

I can't make a request from a form. In the form, I created a button with a macro to open a request. Macro made on the constructor. When I click on this button, it swears that "data type mismatch in the selection condition expression".
Here is the SQl query code:
SELECT *
FROM auto
WHERE (([AUTO]![purchase_date]='[Forms]![AUTO]![Field50]'));

Answer 1

It remains to understand - do the types correspond? :) The request can be simplified, you don't need to use Russian names, field50 should be renamed to a meaningful one and you need to check the type of field50 - what is there now, the date?
If the date is, then perhaps this is a standard rake: the access can use the storage of the date in American format, when the first month, then the day and year. And you most likely have the date entered in Russian.
Then, as it is easy to understand, the query will work exactly as long as your first number is not more than 12. Check if it works on the date 05/12/2016, but not on 05/15/2016, this is it. Corrected by the Format command.