Dependent forms? subforms? (1 Viewer)

[jeo]

I have 3 tables:
tblFunctionalArea
FAID, FAName, Active(y/n)
tblSubFunctionalArea
SubFAID, SubFAname, Active(y/n)
tblLinkFAwithSubFA
FAID, SubFAID

What I need is all possible Functional Areas listed on a form where you can click on active checkbox to activate that Functional Area.
Then on the next form I need Sub-functional Areas listed, but only those that tie back to Functional Areas that have been activated.
Is this at all possible to achieve? I really don’t know how to go about doing this. Do I need a form, or may be I need a subform? I'm at a loss.
Any help would be greatly appreciated.
Thank you.

 

[edtab]

Try searching for cascading combo boxes. There's quite a bit of information on this forum regarding this topic.

 

[jeo]

i don't know if it's really a cascading combo box, i want it more to be like cascading forms or subforms, if there is such a thing.
i don't have any drop downs. i started out with 2 subforms, one for Functional Areas were I can click on Active checkbox listing out all Functional Areas and 2nd subform with SubFunctional Areas where I can click on Active checkbox listing all SubFunctional Areas. Now I just need help narrowing down what SubFunctional Areas are displayed on 2nd subform based on what Functional Areas are active on subform1.
Is that possible to do?

 

[edtab]

Perhaps you should post your a small db with your forms/subforms.
I'll have a better understanding if you do that.

 

[jeo]

OK.
I'm attaching example database.
I have a form in there frmActivateFA&SubFA that has 2 tabs on it: FA & SubFA.
I want to be able to go through and activate certain FA, and then when you click on SubFA tab, I want it to narrow down the list from all SubFA to just the ones that relate to Activated FA on the first tab.
So if on the first tab only Business FA is activated, on the second tab, I want it to display Manager and Supervisor for SubFA.
Does this make a little bit more sense?
Thank you very much for all your help! I really appreciated as I've been stuck on this for a while now without any progress.

 

[edtab]

I think I found the solution to your problem. I will post it tomorrow.

 

[edtab]

Attached is the modified code for your db.
I have added a junction query (qryJunctionFASubFA)
which became the record source of your form "subfrm SubFA".

Examine the code behind the click event of your Activate field.
There is also code behind the FAID as well.

Let me know how it goes.

 

[edtab]

Attached is the modified code for your db.
I have added a junction query (qryJunctionFASubFA)
which became the record source of your form "subfrm SubFA".

Examine the code behind the click event of your Activate field.
There is also code behind the FAID as well.

Let me know how it goes.

 

[jeo]

thank you very much for your reply. i never thought of doing what you had in there, so thank you.
i will try and work with what you gave me. i just need slight changes, i think.
i need it to keep all sub fucntional areas depending on what is clicked on functional areas, e.i. if business and programming is clicked active on functional areas tab, i need it to display subfunctional areas for both of them, not just one. but what you have given me is great and i will work with it, at least this gives me some ideas of how to go about it, where before i was really at a loss.
thank you again for all your help! i really appreciate it.

 

[edtab]

Thank you too. Challenge keeps us growing.