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.