I am working with a tabbed form. On the first tab I have a datagridview with customers in it and a searching textbox. I have that working. On the second tab I am placing another datagridview with customer transactions and other data. The customer transaction table has a CustomerID Column which matches the key column in the Customer table on which the first datagridview is based. I am trying to save the key column value in a textbox so that I can use it to filter the datagridview in the second tab.
I can fill in the textbox that contains the key field from a search from another text box on the form. However, if the user does a partial search (example. types in 'Wil' and it returns a record with Williams when the user is actually looking for Wilson. The user would then be able to scroll down and click on the record with wilson). It is here that I am having trouble returning the key field and placing it in the text box.
I know this has to be simple, but I am new to vb.net. My previous experience is in VBA. I am presently reworking an application I did in VBA.