Solved two cbo in subform

[FahadTiger]

Hi everyone..
I have two combo boxes in a subform and when I choose from the first combo box the data is filtered in the second
The problem is when I go to another record and choose from the combo box, all the previous data disappears
Is there any advice?

 

[mike60smart]

Can you upload your db?

 

[arnelgp]

use continuous form for your subform.
see this demo.

 

[FahadTiger]

use continuous form for your subform.
see this demo.

thank you so much Sir

 

[Faoineag]

Hello everyone, I have a form with a subform on which I have 3 cascading combo boxes, I have thoroughly studied the attached example file, I have adapted it to my database, with the two combo boxes it works for me, instead with three it does not. The boxes are organized as follows: A, B and C. The B depends on the A, the C on the A and the B. I have inserted the same code of the example attached on the new combo box but unfortunately it does not work, that is the data can be seen, but they are not filtered by the previous combo box. Can anyone kindly help me? Thanks

 

[Gasman]

The experts here are very good, but they are not mind readers.
Post the code that you are currently using. Within code tags would also be good, with the # icon

 

[Faoineag]

As I said I used the code from the attached file 3 posts above mine, the only change I made is to add the same code to the extra combo box, so no need to read the mind, just look at the attached example code, that's what I asked for info and I thank those who can help me.

 

[arnelgp]

it is easier to see if you can share a sample db?

 

[Gasman]

the only change I made is to add the same code to the extra combo box, so no need to read the mind,

That's me out.

 

[mike60smart]

I won't bother either with responses like that.

 

[Faoineag]

I try to insert screenshots, hoping you understand

 

[Faoineag]

With the screenshots I sent in the previous message everything works.
The problem starts with the settings you see in the following screenshots

 

[Faoineag]

Can anyone help me?​