Sorry, I'm not asking my question clearly enough. I'm trying to display data from Access on a form, in a datarepeater control. There are two controls in the datarepeater - a combobox and a textbox. The textbox displays the name of
the person, the combobox displays what agency they're in. A person can be in more than one agency.
The combobox datasource is set to display the actual agency name but store the agency id back to the access table. However, when the data from the database is displayed on the form, the ID # displays, not the agency name.
I want to see the datarepeater display this:
John Doe (in the textbox) ABC Corporation (in the combobox)
But what I'm actually seeing is this:
John Doe 10 (this is the ID # for ABC Corporation)
(FWIW, this is an unbound datarepeater.) I use the DirectCast method to fill both the textbox and the combobox with data. The textbox works fine. But I can't figure out how to tell the combobox to display ABC Corporation and not 10.
The only way I can figure out how to do this is by changing the datasource for the datarepeater to include the agency name. I was wondering if there was another way to accomplish this.