filtered subform unshown records when choose another brand

[georgesobhyy@gmail.com]

i have a subform for products which filtered to brands, categories, products...However when I choose a brand and fill its category and product. it is okbut when I try to add another record with different brand and fill its category and product, the other data in the brand record got hiddenPLEAAAAAASE HELP

[ItsMe]

How, exactly, are you filtering? Can you provide details?

[georgesobhyy@gmail.com]

thx for reply
I made two queries one for brands and categories and one for categories and Models.
then in the subform I wrote this codes

Private Sub CboBrand_AfterUpdate()
Me.CboCategory.Requery
Me.CboModel.Requery
End Sub
Private Sub CboCategory_AfterUpdate()
Me.CboBrand.Requery
Me.CboModel.Requery
End Sub
Private Sub CboModel_AfterUpdate()
Me.CboBrand.Requery
Me.CboCategory.Requery
End Sub

[ItsMe]

So the queries are for your forms? Perhaps the combos should have queries that depend on something similar. For instance, what if you make one of the combo's dependent on the other and the form's dependent on the combos?

[georgesobhyy@gmail.com]

Sorry... I am somehow new to access..
could you please how I can make the combo's dependent on the other and the form's dependent on the combos?

[georgesobhyy@gmail.com]

Knowing that when I select the same brand in two different records there data are shown and the other brands records there data got invisible

[ItsMe]

You will need to understand the various properties of the combobox control. I would suggerst setting some time aside and looking at some tutorials. What it seems you want is "Cascading Dependent Combobox"

I have created some tutorials here. You can download them for free. But, it takes time and patience. If you are looking for instant gratification, you may get some via YouTube.
https://www.accessforums.net/showthre...671#post277671

Paste the username and pass into an open text file for ease of logging onto the landing page. From there, you can download the series.