Jim,

Try,

In thisform.MyObject.LostFocus method put:

thisform.ComboBox.RowSource = "SELECT * FROM MyTable WHERE MyField = '" + thisform.MyObject.Text + "'"

Obs.: I suppose that "thisform.MyObject.Text" is a text.
Obs2.: You can put the code in another method (not only in "LostFocus").

Good luck!!!


>I want to use:
>SELECT * FROM MyTable WHERE MyField = thisform.MyObject.Text
>in ComboBox.RowSource property but I get error message that Thisform can be used only in methods.
>
>How to solve this?