BTW, if you use code to set the controlSource, you probably should use the init() method...the activate() fires if the user leaves that form and sets focus back to it.
thisform.lstntm1.RowSourceType = 3
thisform..lstntm1.RowSource = [select name, TRANSFORM((rank/7)*100,"999%") as rank ] + ;
[ from matches into cursor matchesCursor ]
>I have the following code in the activate of a page:
>
>this.lstntm1.RowSource = [TRANSFORM((matches.rank/7)*100,"999%"),name]
>this.lstntm1.RowSourceType = 6
>
Steve Gibson