DLookup, case statements

[ahuvas]

I have a field in my main form that shows values of BMI which is calculated from the users height and weight which they entered on a form attached to the same table. I have a query called BMICalculation which is attached to this field using =DLookup([BMI Calculation, "BMI Calculation"] etc

However for my other variables which I have applied case statements to so I can automatically populate other text field boxes, I cant do it for this can I since its not a value that is stored anywhere? How can I automatically populate a text box in a report if the field is based on a query?

 

[Zaeed]

How can I automatically populate a text box in a report if the field is based on a query?

set its row source type to table/query.
then row source to the query name