Hello
I simply do this
Original source i.e. original data from table
.controlsource = cTable.cField
and the combobox choices from a sql to a array
then .rowsource = aArray_name
.rowsourcetype = 5
.numberofelements = alen(aArray_name)
I had to play with it for a week till I figured it out
>Simple, I'm sure, but how do I get the current value of a field in a view (set as ControlSource) to show as the initial value in a Combobox? I am also trying to use SQL as the Rowsource (pulling from the same view that contains the ControlSource) so the user can get a list of all current values for that field to choose from. Am I approaching this incorrectly? Thanks!
>
>Regards, Renoir