PDA

Click to See Complete Forum and Search --> : Scrollbar-Tool Tip Text through recorset


RaceyTay
Feb 20th, 2001, 08:57 PM
I have an app with a parm form that presents a series of query filters. After the query option is selected and the criteria entered, a tabstrip shows three views of the user's entry from three different tables. The data fields are bound to label controls, and if more than one record is returned the user will navigate with the ado data control. This is fine for most of the query results, but there are certain query filters which will return recordsets of 50 to 100 records. Using the ado data control to navigate this many records is NOT GOOD.

It was suggested to me that I use the scroll bar with tool tip text. The idea comes from the way the scroll bar is used in Microsoft Word where depending on where the scroll bar is, the tool tip text will tell you which page of your document you are on. Can I connect the scroll bar to the adodc to show the P.O. Number in the tool tip text as the scrollbar is scrolled? The idea is when you stop on a P.O. Number in the tool tip text the datafields for that P.O will populate the label controls. If anyone has done this sort of thing before, I could sure use the help. I know it's a lot to ask. Thanks.


RaceyTay