Synchronous Scroll

[Mihail]

Hello !

In a form I have 3 list boxes, based on the same table.
I like to use only one of them to scroll (using the scroll bar or the mouse wheel) and the others two must scroll (automatic) synchronous. I wish to show the same area of records, in all list boxes, at the same time.

Any ideas ?

Thank you !

[ADezii]

1. Why would you have 3 List Boxes based on the same Table?
2. Does each List Box have exactly the same Number of Records?
3. What are the Names, RowSources, etc. for each List Box?

[Mihail]

Thank you for reply, ADezii.

1) I have a lot of information on my database. A lot of tables and a lot of queries with calculations. I use a make-table query to put all this information together. Then I define that 3 list boxes to show this information sorted as I need. I play with the column numbers and visibilities to show, in each list box what I wish.

2) Yes.

3) The names are in my language, of course. For now lets say that the names are lst1, lst2 and lst3. The row source is the same for all list boxes: MyTable.

................

I wish to scroll only lst1 and, automatic, lst2 and lst3 must scroll synchronous (if it is possible). I search for a scroll event (like in VB) but I can't find it. Maybe you (all) have a solution for that.

Thank you again.

[NeoPa]

Why not have all the data in separate columns of the same ListBox control?

[Mihail]

Hello NeoPa. Thank you for reply.
It is possible, of course, but...

First:
I have 7 columns per list. If I use a single list will be 21 columns and the user must scroll the screen to see the information.

Second (most important):
The information is logical grouped in each list box.

Note please that all three list boxes show information (properties) for the same item. It is the reason I like to scroll synchronous.

[ADezii]

The Listbox does not expose any Scroll() or Change() Events which lead me to believe that they cannot be Synchronized based solely on Scrolling. I have created a rather 'Rogue' Solution that Synchronizes 3 Listboxes based on the same Table (Orders of Northwind). The [OrderID] Field in each Listbox will prove that they are in Sync. Before I go on with my usual ranting as to how this was accomplished, I'll post the Demo that I created. If you are actually interested, or have any questions, please feel free to ask.

[Mihail]

Thank you, ADezii for your effort.

But your list boxes don't seem to scroll synchronized.
If I focus one of them (by clicking) only THAT list box scroll, not all.

Is something I do wrong ?

I use 2007, but I think this is not a problem.

[ADezii]

They are Synchronized when the Horizontal Scroll Bar at the bottom of the Form is used.

[Mihail]

Sorry ADezii, but they aren't.

They are synchronized as selected rows. This can be a step forward but it isn't what I am looking for.

More: If the selected item (row) exceed the text box window, nothing happen. (Of course, the rows are selected but the user can't see that).

Thank you again for your interest.
I never think that a task as simple as this one (oops !!!) raise so big troubles.

[NeoPa]

Mihail:
It is possible, of course, but...

First:
I have 7 columns per list. If I use a single list will be 21 columns and the user must scroll the screen to see the information.

Second (most important):
The information is logical grouped in each list box.

I find you second point quite inconsequential (as there are better ways than separate controls to handle that), but your first is compelling. Scrolling (horizontally) between your different sets of data would not be user-friendly :-(

Code could be used to ensure the same record is selected in each one, but handling the scrolling (fully) would require a change to the design of ListBox itself, which is built-in of course.

ADezii may be able to help with some look-alike functionality, which may be adequate.

[NeoPa]

Mihail:
I never think that a task as simple as this one (oops !!!) raise so big troubles.

I'm surprised you'd make that mistake Mihail. Your English is obviously not great, but I can tell you're no fool. This would involve a complete redesign of the ListBox control type (I'm sure you checked out the available events before posting). I can see why most people might think it was an easy task, but I'm surprised that you did.