Call queries that display input boxes multiple times in the report by clicking buttons

Anonymous
2023-01-11T10:57:26.0833333+00:00

Hello,

I have following problem: I created 3 different queries. Two with the call of input boxes and one that only sorts. I call these queries via macro via a button. In the form, this works perfectly. These same queries have the following problem in all reports: For example, I filter with an input box for an order number, which works perfectly the first time.

If I then want to filter for another order number, the input box is no longer called but only searched for the order I entered first.
The second button with the question about the employee then no longer shows an input box and does not display any data records. The last button that contains only a sort query always works. If I close the report and open it again, the whole thing starts all over again.

As I said, these same queries in my forms work without problems. Anyone have an idea?

Thanks, greetings

Caro

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
{count} votes