Using multiple tables to populate entries on a form

[Verbet1005]

I am fairly new to Access10. I have a drop down list based on a table with several entries. When I select an entry from that drop down list I want it to display on the form and I want it to open another drop down list from a different Table to select and display data from it.
Example:
Table A has several items listed.
If I select entry 1, I want it to display the entry and then open a drop down list using Table B to select and display data from that table.
If I select entry 2, I want it to display the entry and then open a drop down list using Table C to select and display data from that table.
If I select entry 3, I want it to display the entry and then open a drop down list using Table D to select and display data from that table.

[zmbd]

Drop down to the bottom of this page.
Click on the vba insights sitemap
look at articles:
41
42
55
156
168
they will answer all your questions about this and then some extra.