Access List box DblClick should expand the item values

[johny6685]

Hi

I have a listbox in my form which will show list of field names in a table. If the user double click on one of the field say for example Location, the list box should reload the data with Location field unique data. such as USA, UK, INDIA, etc...

This is similar to our explorer side bar view which expands the folder on selection.

Please confirm is this possible with MS Access.

Thanks

[Stewart Ross]

Not possible with list box control, but you could try using the treeview control instead. It is more complex to use (you need to load it via code - see for example http://bytes.com/topic/access/answer...eeview-control).

-Stewart

[Rabbit]

It's possible with a listbox. In the double click event, you just build dynamic SQL to reload the listbox. But it probably looks nicer and takes less code with the treeview control.

[johny6685]

Thank you both, I already tried as Rabbit stated, I opened the sub selection in a new floatting pane which will pop-up on double click but I think Tree view suggestion is what I expected. Let me try and get back if I have some questions. Thanks.