One Combobox based another combobox filter

[ZKHADI]

hey guys
i have one combobox in which I store faculty like Pre medical, pre engineering, computer sicne
another combobox have the related subjects of faculty.
i want to filter the combobox by selection of first combobox see in image.
but this not working may be code error.
if I select the pre medical then the another combobox only that subjects show.

 

[June7]

Cascading combobox is a common topic.

Provide code as formatted text, not image. Certainly not using Me.Filter correctly.

If you want to provide db, follow instructions at bottom of my post.

 

[CJ_London]

In a continuous form you need to update the second combo rowsource when the combo gets or loses focus - see this link for an example

enabling cascading comboboxes in datasheet or continuous form

Having been asked about this recently, I reinvented some code I developed to work with datasheets and which also works with continuous and single forms. The attachment was developed in 2010 but saved as 2003. The db demonstrated two techniques for using cascading comboboxes. Technique 1 is...

www.access-programmers.co.uk

 

[arnelgp]

combo gets or loses focus - see this link for an example

that is Not working properly.
on 4th record, if you alternately click on Colour combobox then Product combobox repeatedly, there
will be a time when the Product combo will be Blanked out.

 

[CJ_London]

I’ll take a look when I get back to my desk