General information
Category:
Forms & Form designer
Title:
ComboBox and Grid problems
I have three tables in a DBC. A parent table(presentation), A link table(presobjlink), And a child table(objectives).
I have a grid containing a field from the link table and a field from the child table. When a the user selects a different parent the grid properly displays the link field(s) and the children. It seems correct.
So what I want to do is have a ComboBox that contains all the values for the field from the child table and of course allows the user to create a new value or select a previously entered value.
I have a select statement that builds an array of the values in the child(objectives) table. I also expand the array to accommodate the "new value" a user might enter. I test the ComboBox outside the grid and it seems correct. So copy it into the grid, having removed the default text1 for the column. Now the ComboBox in the grid is erratic (OK so it is my understanding that is erratic). Sometimes it won't drop down the array. Other times it carries the value to the next field. Other times it announces that the control is read-only (this one seems like an eof()issue I have not solved).
Can someone direct me to a source that shows how it is done properly. It does not seem that exotic.
Thanks
John
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only