>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