I have a form that uses a combo box to select data from one table in an Access database and place the selected data in a field of another table. If the field already has data in it, it will show in the combo box on the form and of course the user can select a different piece of data to replace it with should they desire.

The combo box pretty much works as expected, except that it always shows the following as one of the selection values: System.Data.DataRowView. Additionally, when I make a selection from the combo box that selection is replaced (in the box) by the previously mentioned syntax. By the way, the data in the t

I have been toyed with by every type of property change that I can make and this appears to be the best I can do. The properties that seem to effect this is the following:

Data Bindings
Advanced; is set to the field in a table that the data will be placed from the selection and is set to text, not tag
Selected Item; is set to the table and field from which the data will be extracted from
Selected Value; is set to the table and field from which the data will be extracted
Data Source; is set to the binding source of the table from which the data is extracted
Display Member; is set to the field from which the data is extracted
All other properties are in their default condition.

I have attempted every combination I can think of with the above properties and while it works, I cannot get rid of the syntax that shows up in the combo box or keep out the propogation of the syntax in place of actual field values.

Anyone have any ideas of what I might be doing wrong?