how to filter list of items in a combo box by selecting items in another combo

[mmwit]

dears!

I want to list provinces and districts, and want when I selec province 1 all the districts of provinces should only be shown to me in the district combo, and if I select the 2nd province in the province combo the disctrict combo should list me the names of districts belong to 2nd province

also attached is the file, hope this help you

and yeah I should remind you dears, that the app is again Access 2010
[imgnothumb]http://bytes.com/attachments/attachment/6866d1359438355/relationship.jp g[/imgnothumb]

[TheSmileyCoder]

This type of question has been asked over and over again. Please check out http://bytes.com/topic/access/insigh...mbo-list-boxes and also Example: Filtering on a form and if you still have questions come back with them.

[NeoPa]

Another one, for this specific issue, is Cascaded Form Filtering.

[zmbd]

Although related, I've moved the posts by dgalter and Seth into thier own thread: Cascading Combo Box Filtering.

[NeoPa]

A set of posts that started with a hijack have been moved to a new thread (How do I Use Cascaded Filters).

[mmwit]

thanks for your replies I'm working on and will reply you all dear developers about the result, onething more I wanted to mention you all, is it effect anything on having primary keys on both tables, which are in a relationship to each others,

see above pictures I uploaded

Thanks

[zmbd]

mmwit:
That question is barely related to your orignial post...
But is yet a seperate question.
As such it should be in a new thread. You can always include a link to the old thread should you wish to have that information as a reference.

I must insist that you read the following links.
You will be expected to follow the guidlines set forth in them for all future posts:
Before Posting (VBA or SQL) Code.
How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!.
POSTING_GUIDELI NES: Please Read Carefully Before Posting to a Forum.

I have also sent you PM