Thanks for the reply, as you have probably gathered I am quite new to this.
Maybe I should explain in more depth what I am trying to do.
do you have a Key defined on the Items table?
I have now, and that has removed the error, but the code didn't produce the
result I was after anyway.
Also, since you're using a
StronglyTyped DataSet, - not sure you want to referencethe table with
"Items"... if the table name changes for some reason - you wont find out
until compile time when you get an error...
Let's assume for the moment that the table name won't change, because I'm
not entirely sure what the alternative way of referencing it is.
In simple terms this is the situation:-
I have a Dropdown combo box bound to a datasource with datamember set to
"Description"
and a Textbox bound to the "ProductCode" field of the same datasource.
When I select a new item in the combo box the ProductCode textbox updates,
which is what I want.
However I also want to be able to type in a product code and when I press
enter I would like to search the dataset for a match and set the dataset
position to reflect this, which should update the combobox to the
corresponding description.
I hope this newbie rambling makes some kind of sense.
Thanks.