>In the activate method of a form, I wrote:
>
> STORE films.title TO title1
>
> COUNT FOR Films.Title = title1 TO n_copy
> thisform.refresh
>
>The problem it goes EOF() and the form becomes blank

Use SELECT to get count. It doesn't affect open tables.

SELECT COUNT(*) FROM Films WHERE Title = title1 INTO ARRAY laCount