>I have a grid with four comboboxes in it. The current value in the first combobox determines what values are in the second combobox and the second determines the values in the third and so on. So potentially a combobox in one record could have different values than the next record. I can fill the comboboxes according to the initial record but is there a way to do this dynamically for each record. I looked at the dynamic options and didn't see anything that might help. I could just re-fill them after each row change but the value of a non-selected combobox won't be contained in the choices so it won't show up. Is there a property that executes for every record in the grid?
>
>Brad


I did a similar kind of thing in a grid but I had only one dynamic combo box but you can modify it according to your requirement :-

1. I made one array property in form, when the user selected the first column (which was also a combo box), in the valid event I put a select sql statement to redirect the new output to array.(you can change this and put in the when event or gotfocus event of dynamic combo box).

and then I run the requery method.

Hope this helps !!