General information
Category:
Forms & Form designer
>>Sawadee,
>>
>>I have a continual headache with combo boxes. I'm using SQL in the Init of the control ie.
>>
>>this.rowSourceType = SQL Select
>>
>>this.Init -----
>>
>>dodefault()
>>this.RowSource = ''
>>this.RowSource = "Some SQL statement to tmpcursor"
>>this.requery()
>>
>>This works fine when the form is started with about 10 different combo boxes using the same technique. Then I use a RightClick to drop a menu to add things to the maintenance tables that are the source of the combo box lists. Then, after the maintenance form is closed, I try to refresh the list by calling, in DownClick, the same routine that loaded the combo box the first time, which the documentation sez is the best place to add code to make sure your combo box contains the most recent data. ...It don't work. :( I've tried a multitude of permutations of this scenario to no avail. But, if I exit the form and start it again, walaa! Help me.
>>
>>Eric K.
>Eric,
>Set rowsourcetype and rowsource (SQL) in PEM sheet (or keep in init if you prefer) but not requery. In gotfocus just add a this.requery.
>Cetin
Thanx,
BTW, How do I get the combo to search like help, not one character at a time. Setting incrementalsearch seams to have the same effect either way.
Eric K.
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