Report opens parameter form, but then query prompts also

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use a form to enter report criteria. When I open the report,
it opens the form properly. I enter the data, then the underlying report
query prompts me for the same data again. Why is this? When I open up the
form only....it automatically brings up the report. But I would like the end
user to be able to open up the report (and not the form). Any help is
greatly appreciated!
 
I'm not sure I understand...

The report opens the form, but when you open the form, it opens the report?

Usually, if the spelling differs AT ALL between two objects, you'd get
something like what you've reported.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff -
Thanks for your response, I'll try to explain better....
When I double click the report, it opens a form where I select the parameter
data. After I select and enter data, and then press the OK command button
instead of going directly to the preview of the report, I get parameter
dialog pop-ups (pulled from the underlying report query), asking for the same
data.

If I double click the form directly, it works fine. But I want the user to
go to the reports listing, not the form listing. Why does the report request
the parameters a second time?
Thanks.
JKHerman
 
My first guess is still that there's a spelling difference. But maybe your
report doesn't know it is supposed to be looking at the form for its
parameter. Is the report based on a query that has a parameter in it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff -
The report is based on a query. Within the query I have referenced the Form
in the criteria section - For example [Forms]![Certificate of Analysis
Input]![Lot #] where I am asking the query to have the user input the lot #.
Do I need to tell the report that the underlying resource is the form and not
the query?
Jodi
 
Jodi

OK, I'm back to guessing a spelling error. Your report is based on a query.
The query includes a parameter. The parameter "points" to the form. The
parameter in the query and the name of the control on the form have to be
spelled exactly the same. The usual way to get around spelling errors is to
either copy/paste or to, in the query, use the wizard to select the form
control.

Regards

Jeff Boyce
Microsoft Office/Access MVP


jkherman said:
Hi Jeff -
The report is based on a query. Within the query I have referenced the
Form
in the criteria section - For example [Forms]![Certificate of Analysis
Input]![Lot #] where I am asking the query to have the user input the lot
#.
Do I need to tell the report that the underlying resource is the form and
not
the query?
Jodi

Jeff Boyce said:
My first guess is still that there's a spelling difference. But maybe
your
report doesn't know it is supposed to be looking at the form for its
parameter. Is the report based on a query that has a parameter in it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
Click to expand...
 
I agree. Spelling error. OR - the specified field got removed from a/the
query, but is still referenced as a parameter.

jkherman said:
Hi Jeff -
The report is based on a query. Within the query I have referenced the Form
in the criteria section - For example [Forms]![Certificate of Analysis
Input]![Lot #] where I am asking the query to have the user input the lot #.
Do I need to tell the report that the underlying resource is the form and not
the query?
Jodi

Jeff Boyce said:
My first guess is still that there's a spelling difference. But maybe your
report doesn't know it is supposed to be looking at the form for its
parameter. Is the report based on a query that has a parameter in it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
Click to expand...
 
Hi Jeff -
When you say the control on the form - do you mean that the control name
must be the same as the data field in the query? Also, the form works okay,
but it is when I open the report from the report list, where I get this
duplication error. Do I point the report to the form and not the query as
the record source?

Jeff Boyce said:
Jodi

OK, I'm back to guessing a spelling error. Your report is based on a query.
The query includes a parameter. The parameter "points" to the form. The
parameter in the query and the name of the control on the form have to be
spelled exactly the same. The usual way to get around spelling errors is to
either copy/paste or to, in the query, use the wizard to select the form
control.

Regards

Jeff Boyce
Microsoft Office/Access MVP


jkherman said:
Hi Jeff -
The report is based on a query. Within the query I have referenced the
Form
in the criteria section - For example [Forms]![Certificate of Analysis
Input]![Lot #] where I am asking the query to have the user input the lot
#.
Do I need to tell the report that the underlying resource is the form and
not
the query?
Jodi

Jeff Boyce said:
My first guess is still that there's a spelling difference. But maybe
your
report doesn't know it is supposed to be looking at the form for its
parameter. Is the report based on a query that has a parameter in it?

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi Jeff -
Thanks for your response, I'll try to explain better....
When I double click the report, it opens a form where I select the
parameter
data. After I select and enter data, and then press the OK command
button
instead of going directly to the preview of the report, I get parameter
dialog pop-ups (pulled from the underlying report query), asking for
the
same
data.

If I double click the form directly, it works fine. But I want the
user
to
go to the reports listing, not the form listing. Why does the report
request
the parameters a second time?
Thanks.
JKHerman

:

I'm not sure I understand...

The report opens the form, but when you open the form, it opens the
report?

Usually, if the spelling differs AT ALL between two objects, you'd get
something like what you've reported.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am trying to use a form to enter report criteria. When I open the
report,
it opens the form properly. I enter the data, then the underlying
report
query prompts me for the same data again. Why is this? When I open
up
the
form only....it automatically brings up the report. But I would
like
the
end
user to be able to open up the report (and not the form). Any help
is
greatly appreciated!
Click to expand...
Click to expand...
Click to expand...
 
Please re-read my responses.

Paramter goes in the query (parameter points to the form).

Report based on query.

When you attempt to open the report, the query looks to the form for its
data.

If you have been closing the form before opening the report, the report's
query will find ... nothing! ... and will prompt you for the value that
would have been in the form control.

Regards

Jeff Boyce
Microsoft Office/Access MVP

jkherman said:
Hi Jeff -
When you say the control on the form - do you mean that the control name
must be the same as the data field in the query? Also, the form works
okay,
but it is when I open the report from the report list, where I get this
duplication error. Do I point the report to the form and not the query as
the record source?

Jeff Boyce said:
Jodi

OK, I'm back to guessing a spelling error. Your report is based on a
query.
The query includes a parameter. The parameter "points" to the form. The
parameter in the query and the name of the control on the form have to be
spelled exactly the same. The usual way to get around spelling errors is
to
either copy/paste or to, in the query, use the wizard to select the form
control.

Regards

Jeff Boyce
Microsoft Office/Access MVP


jkherman said:
Hi Jeff -
The report is based on a query. Within the query I have referenced the
Form
in the criteria section - For example [Forms]![Certificate of
Analysis
Input]![Lot #] where I am asking the query to have the user input the
lot
#.
Do I need to tell the report that the underlying resource is the form
and
not
the query?
Jodi

:

My first guess is still that there's a spelling difference. But maybe
your
report doesn't know it is supposed to be looking at the form for its
parameter. Is the report based on a query that has a parameter in it?

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hi Jeff -
Thanks for your response, I'll try to explain better....
When I double click the report, it opens a form where I select the
parameter
data. After I select and enter data, and then press the OK command
button
instead of going directly to the preview of the report, I get
parameter
dialog pop-ups (pulled from the underlying report query), asking for
the
same
data.

If I double click the form directly, it works fine. But I want the
user
to
go to the reports listing, not the form listing. Why does the
report
request
the parameters a second time?
Thanks.
JKHerman

:

I'm not sure I understand...

The report opens the form, but when you open the form, it opens the
report?

Usually, if the spelling differs AT ALL between two objects, you'd
get
something like what you've reported.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am trying to use a form to enter report criteria. When I open
the
report,
it opens the form properly. I enter the data, then the
underlying
report
query prompts me for the same data again. Why is this? When I
open
up
the
form only....it automatically brings up the report. But I would
like
the
end
user to be able to open up the report (and not the form). Any
help
is
greatly appreciated!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top