RowSourceChanged Event
The RowSourceChanged event fires when a bound data source is changed or requeried.
object_RowSourceChanged ( )
Arguments
None
Event applies to TDBList and TDBCombo controls.
This event also fires when a bound control is first loaded.
The RowSourceChanged event fires before the control is filled with data. Therefore, you can use this event to initialize the control according to information obtained from the data source, if necessary.
This event does not fire in unbound or storage modes.
Note: With the OLE DB version of True DBCombo, you can use the RowSourceChanged event in conjunction with the BookmarkType property to circumvent type mismatch errors that may occur when a control-supplied bookmark is passed to an ADO Recordset object (or vice versa). The workaround is as follows:
Sub TDBList1_DataSourceChanged()
TDBList1.BookmarkType = VarType(ADODC1.Recordset.Bookmark)
End Sub
This code ensures that any bookmarks returned by the combo are first converted to the appropriate type for the bound data source. This workaround is only needed when using the combo in an HTML page; it is not needed for Visual Basic 6.0.
See Also