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?
Erick
Força Sempre!
Strength Always!