toom
04-17-2011, 03:55 AM
I'm filling a table with data. And I have some control elements like textboxes or comboboxes that are bounded to the fields in that table.
Actually the table contains always exactly one row of data. But that data can change depending on the action the user takes. If the user alters the data in that table I want to get the bounded fields updated. But instead the control elements contain "#DELETED" after modifing the table which is correct since I clear the table everytime before I insert a new dataset. But the newly entered data isn't put into the controls anyway, instead of getting updated it remains on "#DELETED".
So, what I want is a method call that updates all the controls that are bounded to this table. Is there a method in vba that can be invoked and has the desired effect?
Actually the table contains always exactly one row of data. But that data can change depending on the action the user takes. If the user alters the data in that table I want to get the bounded fields updated. But instead the control elements contain "#DELETED" after modifing the table which is correct since I clear the table everytime before I insert a new dataset. But the newly entered data isn't put into the controls anyway, instead of getting updated it remains on "#DELETED".
So, what I want is a method call that updates all the controls that are bounded to this table. Is there a method in vba that can be invoked and has the desired effect?