Hi,

Try to call a function in the text.valid event- thisform.refresh_combo()
e.g.
**** THISFORM.REFRESH_COMBO *****
LPARAMETER sTable
WITH THISFORM.combo1
.RowSourceType=0
.RowSource = 'Select * from '+sTable+' into cursor temp1'
.RowSourceType=3
.Refresh()
ENDWITH


>Hi All,
> I have a combobox that's supposed to display values from one of two tables depending on a condition from a textbox on the same form. Soemthing like:
>
>IF THISFORM.text1.VALUE = 1
> SELECT table1
> ELSE
> IF THISFORM.text1.VALUE = 2
> SELECT table2
>
>How do I phrase my SQL on the RowSource for this to work? Thanks in advance for all your answers.
>
>Richard.