Report design

D

Donna

I redesigned an old form in Access 2000 and realized that a report that is
generated needed updating too. Rather than recreate that I just saved the
form as a report.

When I go to open up the report there is a parameter value that it has
automatically chose which is the Contact Title field. I would like to change
that to a different field which is our control number.

So Question #1: How do I change the parameter value to ask me for a control
number field rather than a contacts title?

The old report opened and was named "Query 1" after you entered the control
number as the parameter.

Question #2: How do I link this new report to that Query?

Don't know if this is enough information to help me, but ask away if not and
I can answer accordingly.

THANKS! all.
 
S

Steve Huff

Donna said:
I redesigned an old form in Access 2000 and realized that a report that is
generated needed updating too. Rather than recreate that I just saved the
form as a report.
Click to expand...

Ok so you created a brand new report from the redesigned form...
When I go to open up the report there is a parameter value that it has
automatically chose which is the Contact Title field. I would like to
change
that to a different field which is our control number.

So Question #1: How do I change the parameter value to ask me for a
control
number field rather than a contacts title?
Click to expand...

So the old form that you redesigned and then saved as a report opens up with
a paramter prompt which is the Contact Title field. More then likely the
"Contact Title" prompt is coming from the query that is bound to the form.
So you need to change the query to prompt for the Control Number instead.
But keep in mind that the query is also bound to the form that you copied it
from so unless you want them both working the same way you need to save the
query with a different name.
The old report opened and was named "Query 1" after you entered the
control
number as the parameter.

Question #2: How do I link this new report to that Query?
Click to expand...

So you are saying you already have the query created that prompts for the
correct paramter? Then all you need to do is change the RecordSource of the
new report to that query. Go into design mode of the report and in the
properties dialog change the Recordsource under the Data tab to the query
"Query 1"
 
Top