Access 97: Populate ListBox based on another ListBox

[Mark Breitfeller]

I need to know how to populate one ListBox based on what
the end users selects from another ListBox.



There need to be 2 ListBoxes (Location and Machine). When
the end user selects the Location from the 1st ListBox, I
want the second ListBox to display ONLY machines in the
selected Location.



I have 2 tables. One table contains all Locations. The
second table contains all machines and their respective
location.



Here are the responses I select when using the ListBox
Wizard, while setting up the Location (1st) ListBox:



How do you want your list box to get its values?
Select: I want the list box to look up values in a table
or query.



Which table or query should provide the values for your
list box?
Select: Location

View Select: Tables



Which fields contain the values you want in your list
box?
Select: Location



How wide would you like the columns in your list box?
Adjusted the column width.



Choose a field that uniquely identifies the row.
Select: Location



Microsoft Access can store the selected value from your
list box in your database, or remember the value so you
can use it later to perform a task.
Select: Remember the value for later use.


What label would you like for your list box?
Select: Location

Finish



Can anyone help me?



Thanks,

Mark Breitfeller