OnScrollBarClick ???

C

ColtsFan

Is there anything remotely like an Event procedure that allows me to run code
everytime the scroll bar is moved? The current record doesn't always change,
so I can't use OnCurrent. Any thoughts? Perhaps a workaround may be code to
always set the current record to the top visible row.
 
S

Stephen Lebans

Unfortunately Access does nto expose any ScrollBar events. What is it you
are trying to accomplish?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
C

ColtsFan

Hi Stephen. I am trying to mimic the "freeze panes" feature in excel. I
have 2 subforms on a form. The subform on the left is a one column
continuous form whose dataset is the fieldnames for the data in subform2.
When I move around in subform2 (which is really long and wide), I need the
left side headings in subform 1 to move with subform2. After a LONG attempt
at using every variation of seltop, currentrecord, etc... I finally stumbled
onto you getsetscrollbar tool. It works like a charm as long as I have an
event to assign it too. however when I just click down the scroll bar, none
of the events set off.

I've had a good suggestion to elminate the scroll bars altogether and create
my own up/down buttons which could call your getset commands. However I
think your getset tools require the scrollbars to be visible.

any thoughts?
 
S

Stephen Lebans

If you eliminate the ScrollBars then you could simply use the SelTop
property.

You might consider searching on this issue via GoogleGroups. I think
Albert(Access MVP) has posted an alternative solution to the issue.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Top