Help with adding some dynamic elements to a report

[Leebo86]

I'm trying to add some elements to a report that I figure need to be populated with code, but when I tried to do this I started getting errors about my report having incompatible elements and it wouldn't let me save. This continued even after I deleted what I assumed were the offending elements.

Basically, I have a report that is bound to a query. The report displays a summary of a selected employee's performance for various tasks.

I want the report header to display the selected employee's job title, which is present in the table of employees. This is what I tried to do with code. I wrote a SQL statement in the On Load portion of the report code that would fill an unbound text box with the job title.

Was I on the right track, or is there a different way to do this?

 

[sxschech]

Perhaps try the DLOOKUP function instead of an sql statement.

 

[pr2-eugin]

You can simply include the Job title in the Query that you are using to form the source of the Report.. and use that on the Report?

 

[Leebo86]

Thanks for the suggestions, I'll see which works best for me.