choosing a table

[chadkan]

I want to be able to make a form in access and choose a table based on
a selection from another table. example, I want to pick a
manufacturing production line (choose from one of five lines).
Depending on what line I choose, I get a list of the machines that the
line I choose has. I hope you can get what I am aking. Thanks

Chad

 

[Jeff Boyce]

Chad

One way to do what it sounds like you're describing is to use "cascading
combo boxes".

Create one combo box that lists your "lines".

Create a second combo box that lists machines, and, as a parameter in the
underlying query that feeds this second combo box, refer to the value in the
first combo box.

In the AfterUpdate event of the first combo box, add something like (your
syntax will vary):

Me!cboSecondComboBox.Requery