Image of Navigational Panel mapped to Contents / Home / Search VBTools 5.0
Tech Support Question
Image of Line Break

Q. Do you have any ideas how I might solve the following problem.

I have a read_only simple database, bound to a 3dlistbox, via a data control. I would like to use the FindFirst routine to find a record in the Recordset, and then set the ListIndex to the appropriate row to show the record.

However, there does not seem to be a way of extracting the current record number from the Recordset.

If this were possible, List.TopIndex could be used to shuffle the list window.

(Note: Findfirst looks up the data OK, but leaves the list window unchanged.)

A. Does this database have a unique field, like m_ID or some sort of indexing? If so, then you can include this in the list box and use that field to do the shuffling.

There has to be a way to retrieve the current record from the record set, and be able to use this in conjunction with the .FindFirst method to do what you are talking about.

Something along the lines of PercentPosition property, AbsolutePosition Property, or RecordCount Property, should be able to provide you with a position pointer to do what you want.

Image of Arrow to Previous Article Image of Arrow to Next Article

[TECH SUPPORT TOC]
Image of Line Break
[HOME] [TABLE OF CONTENTS] [SEARCH]