report

[Joel Allen]

Hello,

I made a bar graph report. From the Row Source property, I went the query
builder. I made a Parameter called "Start Date" so it would show up as a
prompt when I ran the report.

I'm trying to get "Start Date" to show up in the header of the report, but
it is unavailable from the field selector. How can I make this prompt show
up?

Thanks,
Joel

 

[Duane Hookom]

Don't create parameter/prompt queries. Always get input like this from users
with controls on forms. You can reference Forms!frmName!txtName in queries or
control sources.

 

[Joel Allen]

Thanks Duane. Sounds like a good approach. So if I put a field for Start
Date in a form, where is the data stored? Do I tie the field to a table or
something. Sorry, I'm learning!

Thanks Joel

 

[Duane Hookom]

You could bind the control on the form to a table but you don't need to.
Generally the controls used as criteria are unbound. The form needs to be
open and the value entered. Then open your report. A text box in the report
can reference the unbound text box on the form as can the criteria in the Row
Source.