Move pointer in BindingNavigator with a combobox
Posted on 2010-09-03
In my VB2008 I have a form that uses a BindingNavigator and a BindingSource (both on the form) to navigate through a database table (with client information). All buttons on the bindingnavigator work as expected. The fields of the database table are shown in text boxes.
Because there are about 500 rows in the table, I also added a combobox that shows a combination of the last and first names of the clients (= DisplayMember). The ValueMember of the combobox is set at the Primary Key Field of the table.
What I want is this:
- When I select another client name in the combobox, the pointer in the BindingNavigator should move to the corresponding row so that the text boxes are updated.
In my case the Primary Key Field is an integer field named Vrt_ID
When I select another name in my combobox, the valuemember of the combobox is updated to the Vrt_ID of the selected client.
Now I want the BindingNavigator to jump to the field with the same value for Vrt_ID.
How should I do this???
Thanks in advance.