Hello everyone, I have a Form where I have inserted buttons that, if clicked, filter the data of the form. I know it's not the best method to apply filters to a Form, but I'm just trying to understand how some dynamics work, with some exercises that aren't very sensible. So I created various data including the "price" group with values from 0 to 2000, and I created a normal button with a macro with a filter function, with a Where condition:
[price] Between "0" And "1000".
Then I created a macro button that opens the report, and I created a query to match the report that contained all the data including "price". Now I had already done a similar exercise with a combo box and in the query that I had matched to the report I had put, in the criteria:
Like Nz ([Form]! [PrizeForm]! [Combobox1]; "*")
and it had worked very well, but now if I use the "like Nz" with the normal filter button that I explained above, it doesn't work. So how do I link the report with the query to the filter button results in my form?