Help with set of combo boxes

[Guest]

I am creating a form to be used for indexing newspaper articles. Depending on
what the user types into the field [Topic] (which, incidentally is also in a
Combo box), I would like to have the appropriate table for subtopics to show
up in the combo box for [SubTopic]. Not all topics will have a corresponding
subtopic table.

Am I structuring this correctly, or should it all be done in one table
somehow? What code do I use? I assume it goes in the RowSource property?

Thanks for any help!!!

 

[Van T. Dinh]

That sounds fine.

See The Access Web article for sample code:

http://www.mvps.org/access/forms/frm0028.htm

 

[Guest]

Thanks so much, Van. I used this code as a starting point for what I wanted
and it actually works!!!

That sounds fine.

See The Access Web article for sample code:

http://www.mvps.org/access/forms/frm0028.htm

--
HTH
Van T. Dinh
MVP (Access)

I am creating a form to be used for indexing newspaper articles. Depending on
what the user types into the field [Topic] (which, incidentally is also in a
Combo box), I would like to have the appropriate table for subtopics to show
up in the combo box for [SubTopic]. Not all topics will have a corresponding
subtopic table.

Am I structuring this correctly, or should it all be done in one table
somehow? What code do I use? I assume it goes in the RowSource property?

Thanks for any help!!!