Controlling Subform with Multiple combo box

[glen]

Hello friends,
I created one form with two combo boxes and one sub-form.
I want to control this sub form from this two combo boxes means first I will select Department then Location.In every department there will be two locations.
Location1 and 2.
it should show me records separately of location1 and 2 when I select them.
see the attached image.

[orange]

Google Cascading Combo boxes

or watch the free video tutorial at
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[glen]

here is my form design

[orange]

Did you watch the videos? Do you have a specific problem?
Can you present the problem with some data?

[glen]

Yes I watched videos
the problem is now that combo box selection is no working.
If I select Factory A or B records in sub form is same not changing.

[orange]

Please show the RowsourceType and RowSource for each of your combo boxes.
Please post a jpg of your Tables and relationships.

And a description of your application and what exactly is the purpose of this form.
The better we understand WHAT you are trying to do, the better your chances of getting advice.

[glen]

Here is my database, you check and advise.
The main purpose of this database is to issue stationary to two different factories in same departments.
https://www.box.com/s/6b5aeac1fc3ed8cc3616

[orange]

As per the line at the bottom of my posts -- I can NOT use accdb files

[glen]

https://www.box.com/s/fbd385055e29d1b61bf6
check this one in .mdb format.

[orange]

I saw your database. You do not have a complete data model (tables and relationships).
I think you are missing an Order Entity.

You have not populated the LinkFields for the Form and Subform. I think you should name your forms so that one doesn't have to guess what they are.

You can use tbl as prefix to Table names, frm as prefix to Form names etc.

Can you give, even in point form, an overview of what the Forms and subforms are and what exactly you want them to do.

It isn't clear to me what exactly the problem is, because I have no ideas what the purpose of the form(s) is/are.

[glen]

Mr. Orange I am not too familiar with access.
The purpose of my database is very simple.I have to issue stationary to two different factories.
from the first combo I will select Department name i.e "Production" then I will select Factory"A" from Second combo so it will show me records which I issued before in sub form.
Now Department will b same "Production" and I will change in second combo "Factory B" so it will show me records or if I want to issue new material in sub form.
Don't go with my database which i given here bcoz I know it is not rightly designed.
you just give me a demo that how I can use two combo boxes with one sub form?

[orange]

The issue is NOT your familiarity with Access. You are attempting to create forms and create processes before you have designed your tables.
It is a common issue with many novice database "developers".
However, you must decide and understand in Business Terms, exactly WHAT it is you are trying to solve.
Then, create your data model and see if it supports your requirements. This is an iterative process.
Each time you find some anomaly, you must resolve it by either adjusting the data model or resetting the related business facts.
At some point you will have established a workable data model from which you can create tables and relationships.
Then, you can address form design and user interface.

My earlier comments were about forms and subforms, but since are saying your design is not correct, I am trying to help you with design.
Your can read this tutorial and see if you can apply it to your situation.

http://www.rogersaccesslibrary.com/T...lationship.zip

[glen]

Ok thanks I will try.