General information
Category:
Forms & Form designer
I allways use RowSourceType = 0 and populate the combo in the Refresh() method with AddListItem(). This give me more flexibility in what I actually put in the combo.
In your case, you could refresh your view in the Refresh() and insert the valid records in the combo with AddListItem().
>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only