>Well I finally hacked my way through it. Changed to thisform.array and was able to get the results I needed. Talk about a wasted Friday night.
>
>Gaylen
>
>
>
>I have a form with two text boxes and a grid on them. One text box is policy number the other is year. When I enter the year and policy number the grid is populated with officers names for that year and policy. One of the columns in one of the grids has a combo box that will display another piece of information about that policy which the client can pick from. That work the first time I do it
>
>When I change to a new policy and year the grid displays the new officers but the combo box continue to hold the values of the first policy and year. I am using sql statement as the rowsource for the combo box as follows.
>
>
>Select cc from officerfile where policyno = thisform.policyno and yr = thisform.yr into cursor xxxxxx
><\pre>
>
>How can I get the combo box to recognize the new values.
>
>Thanks
>
>Gaylen
The combobox values changed during the form life, therefore you should update the values in the comboboxx, like this:
formset.form.grid.field.combo.requery
formset.form.grid.field.combo.refresh
Joaquim