selecting item on form to display form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken - 30 Apr 2008 16:35 GMT

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

Reply to this Message

Marshall Barton - 30 Apr 2008 18:11 GMT

>What would the best way be to select one item, from several lists of items.
>Sorry thats the best way I could say it.
[quoted text clipped - 3 lines]
>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message