I have a grid which is populated with data from a view. I have list box controls in many of the columns which have values in them. I programmatically refresh the grid with code to assure that the Grid and View are Requeried and reflect any changes made to the underlying data. Problem is I have lost the Values I loaded into the Combo boxes when running the form. What is correct syntax to make sure the values are loaded into the combo box?
Right now I use in the activate event:
Thisform.grdInt.recordsource = ""
Thisform.grdInt.recordsource = "rmtinterventions"
Thisform.grdInt.column1.controlsource = "rmtinterventions.verb"
Thisform.grdInt.column2.controlsource = "rmtinterventions.subject"
Thisform.grdInt.column3.controlsource = "rmtinterventions.outcome"
I have values in the combo boxes for columns 1, 2, and three which are missing when the form is run.
thanks
Some days it's not worth chewing through the leather straps ...