selecting item on form to display form

[Ken]

What would the best way be to select one item, from several lists of items.
Sorry thats the best way I could say it.
I have 8 categories of items, with say 50 items each. Each item would
provide the information, when selected to populate another form.

I set up 8 different list boxes on the main form, and then not sure if this
is best way to a solution for this.

For one thing, to start someone could select one item on each list box, then
what?

If you could just give me a basic idea, and or design route, I would
appreciate it.
Ken

 

[Marshall Barton]

What would the best way be to select one item, from several lists of items.
Sorry thats the best way I could say it.
I have 8 categories of items, with say 50 items each. Each item would
provide the information, when selected to populate another form.

I set up 8 different list boxes on the main form, and then not sure if this
is best way to a solution for this.

I normally use one combo box to select the category and a
second combo box to select the item. The item combo box
would only display the items in the selected category by
setting its row source query to use the category combo box
as criteria. I.e. The query's category field's criteria
would be like Forms!yourform.categorycombobox.

The category combo box;' AfterUpdate event and the form's
Current event would both use a line of code like:
Me.itemcombobox.Requery
to synchronize the lists.