Populate list box from a combo box. List box must be able to show record

[Kaosman]

I have been trying to figure out this problem for a while.

All I want to do is have a combo box populate a list box and the list box change to the record based on the users choice.

The combo box is active and find a record based on user input.

The list box gets its values from the combo box and the list box can also change the form to the record chosen by the user.

The list box and combo box are on the same form.

Help needed :)

TIA - kevin

[missinglinq]

Perhaps I've misunderstood, but why would you need a combobox and a listbox on a single form, both of which can be used to find a record?

Welcome to Bytes!

Linq ;0)>

[Kaosman]

What I need:
The first list box pulls all records from the query with no filter.

The second list box only shows records that have been grouped together by category. So for example if there are 100 records in the table total and 10 of those have been grouped with name "website" as the category. If any one of those 10 records are looked at the second list box will auto populate with the rest of the records in the "website" group only.

Then any one of those records on second list form can be clicked and form will change to that record.

Im thinking "NOW" that the best way to get the results from for the second list box is not from the first list box but from the group category. Somehow I need to code the second list box to show all the records in which they are grouped together for the current viewed record on the form. The user will see all the other records in the list box that are grouped in the same category and be able to click them to have the form change to that record.

Remember this is all happening on the same form, no popup forms or other stuff, just a simple lookup of similar records that can be clicked like a regular list box would allow.

I hope I am explaining this correctly.

The key is to have the second list box show only the records that match the current record being viewed by the user. If the user sees another record they want to look that are in the same group they would click it and the form would change to that record.


thanks

kevin

[missinglinq]

This is a variation of Cascading Comboboxes/Listboxes. Here's a tutorial on the subject by Rabbit, late of our site:

http://bytes.com/topic/access/insigh...mbo-list-boxes

Linq ;0)>

[Kaosman]

Thank you i will study the link you sentthis evening.


Thanks again :)

[Kaosman]

Enclosed is my movie database, it is very simple in design. I just need the green List Box to work as it should and only show those records that are grouped in the same group as the current record being viewed. This way I can see all the other movies that are in the same group in the green List Box and be able to click them to see the record details on the main form.


Thanks for taking your time to help


kevin