Data related question

[Tony K]

I'll try and make this as clear as mud. I have a Windows form with details
and a DataGridView connected to an Access database. I have just learned how
to control which cells in the DataGridView have been modified so I can
perform an action when the particular cell is modified. What I have is a
DataGridView column with a ComboBox but when that combobox has a selected
value, I want the textbox next to it to display a value from the database
based on my SELECT statement.

My SELECT statement is as follows:
SELECT ProductDescription, ProductID
FROM Products
WHERE (ProductIDNumber = ?)

I guess what I want to know is how would I assign the ProductDescription and
ProductID to variables and not... say a text box. My stupid workaround now
is bind textboxes to the 2 fields, grab the text property then use it in a
variable. The textboxes visible property is set to false on the form.

Is there a better way to code this? I've always been more of a drag and
drop type of person so the more detailed code the better I'll understand.

Thank you,
Tony