>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?
Assuming that thisform.MyObject.Text is valid
(Try WAIT WINDOW TRANSFORM(thisform.MyObject.Text) and see what appears. If it's not text then that's your problem)
I have found that SQL does not like thisform so...
mText = thisform.MyObject.Text
SELECT * FROM MyTable WHERE MyField = mText
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn