Form variables in a Report

[caroline.j]

I hope this is just me missing something simple.

I have a basic form report which displays a number of fields concatenated together and stored in a form variable - however when I display more than one record on a page the variables are not updating! Where do I need to put the method so that it is run??

Many thanks in anticipation.
Caroline

[Thomas Parry]

onRecordSelect ?

[caroline.j]

That is where I had it but it doesn't appear to run the routine more than once?

[Joas]

A form variable is unique for the form, not for the record.
In your case it is better to use a calculation, that is unique for each record and is calculated automatically when shown.

[caroline.j]

Thanks for that Joas.
Just out of interest is there much overhead to the table if you have many calculated fields?