>>>>In my grid class, I put code to set up the grid according to saved settings:
>>>>
>>>>
>>>> RESTORE FROM MEMO Settings ADDITIVE
>>>> THIS.RecordSource = THIS.RecordSource
>>>> FOR i = 1 TO THIS.ColumnCount
>>>> THIS.Columns[i].Header1.Caption = laSets[i,1]
>>>> THIS.Columns[i].ControlSource = laSets[i,2]
>>>> THIS.Columns[i].Width = laSets[i,3]
>>>> THIS.Columns[i].ColumnOrder = laSets[i,4]
>>>> ENDFOR
>>>>
>>>>
>>>>For the most part this works, but there's one problem. Comboboxes in the grid don't initialize. I have the cbo rowsource as an SQL statement and the rstype as SQL. When I don't have this code in the grid, the combobox opens a table and creates a cursor and populates itself. With the code, it doesn't do any of that.
>>>>
>>>>I've narrowed it down to it being setting the controlsource that's causing this. Without that line, the cbos work. Unfortunately, without that line the columns have no control sources.
>>>>
>>>>Any idea what I can do to make this work?
>>>>
>>>>Thanks,
>>>>
>>>>-Michelle
>>>
>>>How big is grid.recordsource (i mean number of records)?
>>
>>About 7 right now. Just test data.
>>
>>-Michelle
>
>No, I'm asking about real size. Also, what is this, view or cursor?
It's a view. You mean what size will it be with real data? Probably not more than a thousand records.
Thanks,
-Michelle