>Is there an advantage or difference between setting a rowsource to FIELDS as opposed to ALIAS?
>
>I have a combo box that works intermittantly. It has two columns, is bound to one table, and has a rowsource from another table. When I click on the combo box and make an interactive change, I want to change the record pointer in the rowsource. I used the interactive change method:
>
>SELECT MyTable
>LOCATE FOR Id = cmbTest.value
>THISFORM.refresh
>
>Sometimes this works. Other times I click on the combo box and it does nothing or flashes and doesnt change to the record I picked.
>
>Using the debugger causes it to behave correctly.
>
>Any ideas?
AFAIK, fields and alias is quite similar to "browse" and "browse fields". If fields, you define the fieldlist in rowsource, if alias, columncount specifies how many fields starting from left will be in list.
When rowsource is fields or alias you don't need to use interactivechange to move rec pointer, it moves by default. Furthermore in interactivechange code changing workarea then refresh could cause other side effects. Try w/o interactivechange code.
Cetin