Form and subform

[jcb267]

Hi -



I have created a database that has 3 main tables (provider site, provider, member), a couple of queries and a couple of forms. Everything seems to be working fine, but now I need to make a change and cannot get it to work.

The most important form in a data collection form for each member. Currently, the form lists all provider sites in the database then a subform on the same form lists all providers associated with that particular site and yet another subform lists all members associated with a particular provider. It is rather confusing!

What I would like to do is have a drop down menu where the user can just choose a provider site then base on the selection by the user of the provider site, have another dropdown that will show you only the providers associated with that site. Next, I would like a dropdown that lists all of the members associated with the chosen provider. Finally, when the user chooses a member, a list of questions for that member will appear.

Confusing! I hope that makes sense!!

Please help!!!

[RuralGuy]

See if this thread sheds any light on what you are trying to accomplish: https://www.accessforums.net/access/...html#post81275

[jcb267]

OK, Thanks! I am reading through it now......

See if this thread sheds any light on what you are trying to accomplish: https://www.accessforums.net/access/...html#post81275

[RuralGuy]

Be sure and follow the two links in that thread as well.