Recent content by Faoineag

Thank you, I have modified the code, added a report and it now works. I enclose the db with the code in case anyone needs it. Thanks again

I thank you, but the problem remains: the items are filtered correctly, in the sense that if I select the checkbox in the mask, the items with the selected checkbox appear in the report that opens, and vice versa, but the same report always opens. To explain further, the correct result should...

Thank you. Now the code works, in the sense that the report is filtered by both the two combination boxes and the checkbox, but the same report always opens as a file, even though the data of the two are different in the sense that they correspond to the two reports. Where am I going wrong?

Good evening everyone, as you see corresponding thread in Forms and Vba, your help has enabled me to filter a subform with 2 combined drop-down boxes and a checkbox and subsequently open a report. Now I would like to add a feature: if the checkbox is selected, clicking the button opens Report 1...

Everything perfect, THANK YOU!

It works perfectly! Thank you very much. I'll try to ask you for some more help if you can: after applying the filters I would like to open a report, I have created a button on which, on the click event, I enter the same code, but I get an error, maybe this is not the procedure? Thanks again

@arnelgp: First of all, thank you for your availability. It seems to me, however, that it still doesn't work: try selecting the record ‘A.D.3_...Dischi da Competizione’ from the cboSceltaSottoCategorie, in the cboSceltaTipo you have ‘Dischi da gara’ and ‘Dischi da gara 2’, if I select ‘Dischi da...

Ho ristretto di nuovo il db, lo allego

In the first attempt to send it I forgot to compact the db, I attach the screenshot of the new link from which to download the db. Thank you

I have eliminated as much useless data as possible for the purposes of this filtering research that I am doing, I hope it is sufficient. Thanks for your time. I inserted the file on WeTransfer but after inserting the link here on the forum I cannot send, I do not remember how I did it last year...

Even if I add square brackets to the subform name, when I select an item from the first combo box the subform becomes completely empty.

@cheekybuddha I checked the name of the subform control and it is Prodotti_Attrezzature_Atletica; after changing the code like this: Private Sub FiltraSottomaschera() Dim strfiltro As String strfiltro = "" ' Filtro per SottoCategorie If Not IsNull(Me.cboSceltaSottoCategorie)...

@arnelgp: maybe I don't understand the question, but the filter on cboSceltaTipo is not this: ' Filter for Product Type If Not IsNull(Me.cboSceltaTipo) Then strfiltro = strfiltro & "IDTipoProdotto = " & Me.cboSceltaTipo & " AND " End If

@cheekybuddha I changed the filter name as you indicated, but the result does not change; @CJ_London: I inserted in the sub FilterSubform Debug.Print strfiltro and in the immediate window this appeared: IDSottoCategorie = 348 AND IDSottoCategorie = 348 AND IDTipoProdotto = 113 AND...

Good morning everyone, I would like to filter a form with a datasheet subform with two cascading combo boxes and a checkbox. The form is called "SottoCategorie_Attrezzature_Atetica", the subform smProdotti_Attrezzature_Atetica; in the header of the form I inserted the two combo boxes and the...