Hello,
I'm trying to figure out how to do it the most easy and straightforward way (as always :-)):
I have a combobox, which I fill with a Cursor.
SELECT This from That WHERE ThisField = ThatVariable INTO CURSOR WellWell
Rowsourcetype = 2, Rowsource = "WellWell"
Now, The contents of this Cursor have to change sometimes due to the change of the variable "ThatVariable", so should the contents of the Combobox.
However, I don't like the approach to make the SQL again, then to fill (or Requery?) the combobox again with it's contents.
I could use instead of a Cursor a parameterized view, and I guess this view will be refreshed automatically when I trigger the Combo.Requery() event.
But I am not very experienced with comboboxes, so what is the easiest way of doing "it" according to more experienced programmers?
Christian Isberner
Software Consultant