We want to write a SQL statement in a ComboBox RowSource with a Where clause depending of an Entry Field of the same Form.

The only way we have found is to put the EntryField.value in a Public Variable and do :
Select field1 from Table1 Where Table1.Field2 = PublicVariable

It does not work when we want to do :
Select field1 from Table1 Where Table1.Field2 = ThisForm.EntryField1.Value

If someone have an idea about the right syntax !!!

Analystik team.