Synchronize two combo boxes

  • Thread starter Thread starter Bob Howard
  • Start date Start date
B

Bob Howard

I would like to have two unbound combo boxes dispaying different portions of
the same underlying query on two places on the form. I want the user to be
able to scroll one, and have the other one scroll in sync with the first
one.

Best would be if that second one didn't even have a scrollbar (less
confusing to the user)!

The query behind these combo boxes is not the query the form is bound to ---
it's other data.

Any clues?

Bob (@Martureo.Org)
 
Bob Howard said:
I would like to have two unbound combo boxes dispaying different portions of
the same underlying query on two places on the form. I want the user to be
able to scroll one, and have the other one scroll in sync with the first
one.

Best would be if that second one didn't even have a scrollbar (less
confusing to the user)!

The query behind these combo boxes is not the query the form is bound to ---
it's other data.

Any clues?
Click to expand...

First I would ask Why? Second, did you mean to say ListBoxes? Only one
ComboBox can even be dropped at a time much less figuring out how to make them
scroll in synch.
 
oops! I meant List Box.

The reason is aesthetic / human factors / etc.

Not a biggie!

Bob.
 
Bob Howard said:
oops! I meant List Box.

The reason is aesthetic / human factors / etc.

Not a biggie!
Click to expand...

So what did you mean by "different portions"? You mean that one has rows 1 -
100 and the other rows 101 - 200 (something like that)? If so I'm not sure if
it's possible. I'd have to experiment a bit.

Stephan Lebans does a lot of amazing work with the standard Access controls and
(I think) some of it has to do with controlling the scroll position of a
ListBox. You might want to check his web site.
 
What I meant was that some columns appear in one listbox, and other columns
appear in the other. The two would have the same physical height on the
form so they would each hold the same number of rows. When the user scrolls
one, the other would scroll "by itself."

I've checked that site and not found what I need for this...

Again, this is not a biggie!

Bob.
 
Bob Howard said:
What I meant was that some columns appear in one listbox, and other columns
appear in the other. The two would have the same physical height on the
form so they would each hold the same number of rows. When the user scrolls
one, the other would scroll "by itself."

I've checked that site and not found what I need for this...

Again, this is not a biggie!
Click to expand...

In my playing around if they both have the same bound column and you have the
AfterUpdate event of each set the value of the other to agree then they will
scroll together when you make a selection and then scroll with the up and down
arrow keys on either list. They will not however scroll together when you
actually use the scrollbars.
 
Thanks! I'll check into it! Sorry for the silly questions, but I'm in the
midst of a big application and I know so little about Access. Bob.
 
Back
Top