Print parameter from Argument question

S

Sunny

Hi all,

I am passing DeptName to my report. I am assinging this value to cDeptName
variable in open event.

Now on report header I have text box (txtDeptName) and I am setting
controlsource = cDeptName, but when I open the report, Enter Parameter Value
box poped up and asks for cDeptName value!

I know I can setup txtDeptName = cDeptName in open event and it works fine
but is there any way I can define variable in report and use in the report
for calculation or something else?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub report message 19
Access 2007,reports,VBA 2
Parameter input with no parameter set up 3
report parameter 2
Crosstab Graph Report not showing Parameters in text box 3
Automatically Enter Parameter Value 2
Rogue Parameter Value 2
print a date range from parameter query on a report header? 2

Top