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