[RESOLVED] [2008] Add look up to Binding Navigator

[engnouna]

Hi

I have a form that contains a Binding Navigator which is bound to Table "Customers" Database "Northwind".I have added to the Binding Navigator a ToolStripComboBox1 containing all the "CompanyName" of this Table.When the user selects an item from this ToolStripComboBox1,I get its corresponding CustomerID.What should I do then to display the record of the selected Customer?(I have a set of textboxes bound to each field of the table "Customers")
CustomersBindingSource.Position = ??

thanks

[jmcilhinney]

myBindingSource.Position = myBindingSource.Find("CustomerID = " & customerID)

where customerID is the value you got from the combo box and myBindingSource is the BindingSource associated with your BindingNavigator.