I have a grid that has a combo box in one column and I am trying to have each record that is displayed in the grid to display the fields from a table who's name is in another text box in the grid. I am able to populate the combo box but the information that is displayed is from the text box of record 1 and not its corresponding record. I am hoping someone can tell me how to accomplish this or if it is even possible to do.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
changing data in a combo box
- Thread starter FOXPROG
- Start date
Olaf Doschke
Programmer
putting a combo into a grid you will have a single combo for all rows. That's the way te grid works, it's repeating the display of a sinle row, it's not creating a number of controls for each row.
You could use some Dynamic... property to call some code changing the Rowsource of the combobox, but even then you'd have the problem the rowsources would change and the combobox would always reset to no choice when you change the row.
I wonder why you would have so much individual child tables you need to show in that combobox, you may rethink your table design.
Bye, Olaf.
You could use some Dynamic... property to call some code changing the Rowsource of the combobox, but even then you'd have the problem the rowsources would change and the combobox would always reset to no choice when you change the row.
I wonder why you would have so much individual child tables you need to show in that combobox, you may rethink your table design.
Bye, Olaf.
- Status
Similar threads
