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 !!!