>My form opens two tables in it's load method: persons and countrys. Every person record has a birth country code. The countrys table has a country code field and a description.
>
>In the load method I also set a relationship from birth country code in the persons table into country code of the country table. (All the indexes are set).
>
>I've placed a textbox on the top of the form that is tied to country.description. I also placed a grid on the form and tied each of the columns to a field in the persons table. The grid's control source is the persons table.
>
>In the grid's AfterRowColChange method, I added thisform.refresh. The desired result is that the country description for that person's place of birth will be displayed in the text box above the grid.
>
>However, I found that the only way I could get the textbox to display the proper data as I moved within the grid was to add "go recno()" in the refresh method of the textbox.
>
>If a relationship is set up from persons into country and the grid moves the record pointer in persons and the textbox is tied to a field in country, why won't the textbox refresh with a "thisform.refresh"? Why does it take the extra "go recno()" to get it to display properly?
>
>Thanks for your help!

Rodd,
Try :
select Alias && whatever it's - couldn't understand well
thisform.refresh
Cetin