ListBox RowSource from Different Tables

[Rabbit]

Dear All,

In our department, we have different kinds of trainings:

1. TU (Training Unit),
2. Overseas,
3. InHouse (for local in our department),
4. External (local but not in our department)

Each will have it's own source tables:
tblTU, tblOverseas, tblInHouse, tblExternal

I want to create a Entry Form, user select from a combo box of the above
items.
Can a ListBox display according to the user's choice from the combo box?
Example: user selected Overseas, a list of overseas training course will be display in the ListBox for user to choose from.
Second thought, may be not a ListBox, how about ComboBox2?

Rabbit

 

[John Big Booty]

Why not store all your training in the one table and then use add a type indicator field (integer type) to your table you can then use an option group to indicate the type of training represented by that record. You can then easily filter your result by the indicator field, which in turn will eliminate your current problem.

 

[Rabbit]

Why not store all your training in the one table and then use add a type indicator field (integer type) to your table you can then use an option group to indicate the type of training represented by that record. You can then easily filter your result by the indicator field, which in turn will eliminate your current problem.

Dear John,

At the beginning, I thought about putting all the Trainings in one table, just do not know how to differentiate their types. I am not familiar (new to access), with the "type indicator field". I sounds wonderful and better already.
Try to explore some information on this field!

 

[John Big Booty]

Here's one way you might approach this problem.

 

[Rabbit]

Here's one way you might approach this problem.

Good lord, you have solved all my worries! All I have to do is add another items of Training course Title and Organizations.
Thanks so much!

You guys are God!

Rabbit