Hello!
I have a form (A) that contains a subform (B). Now, the B shows registers from a query that is defined with an SQL. I would like to make this SQL change on order to contrain the dates of the registers shown.
In other words: Now the subform (B) shows registers from dates fixed in its SQL definition. But I would like to change that definition depending on the year an user wants to type down o a text box in the main form.
How to change that sql in the subform in order to achieve that result. I found no way to do it at present.
I have a form (A) that contains a subform (B). Now, the B shows registers from a query that is defined with an SQL. I would like to make this SQL change on order to contrain the dates of the registers shown.
In other words: Now the subform (B) shows registers from dates fixed in its SQL definition. But I would like to change that definition depending on the year an user wants to type down o a text box in the main form.
How to change that sql in the subform in order to achieve that result. I found no way to do it at present.