UnboundFindData Event (TDBCombo)
When a list or combo control is activated, it will attempt to position to the record that matches the current cell text of its parent control.
object_UnboundFindData (StartLocation As Variant, ByVal ReadPriorRows As Boolean, ByVal IncludeCurrent As Boolean, ByVal Col As Integer, ByVal Value As Variant, ByVal SeekFlags As Integer, NewLocation As Variant)
Arguments
StartLocation is a bookmark that specifies the starting row for the search.
ReadPriorRows indicates the direction in which the list or combo control is searching for data. If False, you should provide data in the forward direction starting with the row specified by StartLocation. If True, you should provide data in the backward direction, starting with the row specified by StartLocation.
IncludeCurrent indicates the inclusion of StartLocation in the search. If False, you should not use StartLocation when searching for data. If True, you should include StartLocation in the search.
Col is a column index that specifies the data column for the search.
Value is the value to be searched for.
SeekFlags is an UnboundFindConstants value that provides additional information about how the search should be performed.
The NewLocation argument is initially Null. However, before returning from this event, you should set it to a bookmark that uniquely identifies the row where the data was found. If you do not set the value of NewLocation, it is assumed that no values match and the drop-down will be positioned at the first row.
Event applies to TDBList and TDBCombo controls.
To do this, the control will fire the UnboundFindData event, which allows you to set the current record position within the control.
The SeekFlags argument specifies how to compare the Value argument to drop-down column data:
dblSeekLT |
Find first column data less than Value |
dblSeekLE |
Find first column data less than or equal to Value |
dblSeekEQ |
Find first column data equal to Value |
dblSeekGE |
Find first column data greater than or equal to Value |
dblSeekGT |
Find first column data greater than Value |
dblSeekPartialEQ |
Find first column data that partially matches Value starting from the first character position |
Note: This event will not fire when DataMode is set to 0 - Bound.
See Also