Printing Report

[Guest]

HELP!!

I currently have a query that has that has [Please enter case number] in the
criteria section. When i want to print a report from an open form, i would
like the "Case number" entered automaticly from the open formed field "Case
Number" so the user doesnt have to enter the case number for the report.

 

[Pat Hartman \(MVP\)]

Rather than prompting for the case number, add a combo or text field to your
form. Let the user select the case number or type it in the form. Then
change the report's RecordSource query to reference the form field rather
than prompt:

Select ...
From ...
Where somefield = Forms!yourformname!yourcontrolname

 

[Guest]

I have the field on the form for case number that the user types it. but
where do I change the recordSource query to reference the field for the
report to print only that data that equals that field.

I currently have the user prompt for the data from the query to enter the
case number. I want the report to pull that data from the open form so the
user doesnt have to enter the case number again when he/she has to print the
report.

Sorry, this is a hard one for some reason.

Thanks--
Kevin Sebring
Atlanta Georgia

Rather than prompting for the case number, add a combo or text field to your
form. Let the user select the case number or type it in the form. Then
change the report's RecordSource query to reference the form field rather
than prompt:

Select ...
From ...
Where somefield = Forms!yourformname!yourcontrolname

HELP!!

I currently have a query that has that has [Please enter case number] in
the
criteria section. When i want to print a report from an open form, i
would
like the "Case number" entered automaticly from the open formed field
"Case
Number" so the user doesnt have to enter the case number for the report.

 

[Pat Hartman \(MVP\)]

Just replace the prompt field with the reference to the form.
1. Open the report in design view.
2. Open the properties dialog for the report
3. On the data tab, click the build button next to the RecordSource name.
4. Replace the prompt which probably looks something like:
[enter your data here]
with
Forms!yourformname!yourfieldname
5. Save the change

I have the field on the form for case number that the user types it. but
where do I change the recordSource query to reference the field for the
report to print only that data that equals that field.

I currently have the user prompt for the data from the query to enter the
case number. I want the report to pull that data from the open form so
the
user doesnt have to enter the case number again when he/she has to print
the
report.

Sorry, this is a hard one for some reason.

Thanks--
Kevin Sebring
Atlanta Georgia

Rather than prompting for the case number, add a combo or text field to
your
form. Let the user select the case number or type it in the form. Then
change the report's RecordSource query to reference the form field rather
than prompt:

Select ...
From ...
Where somefield = Forms!yourformname!yourcontrolname

HELP!!

I currently have a query that has that has [Please enter case number]
in
the
criteria section. When i want to print a report from an open form, i
would
like the "Case number" entered automaticly from the open formed field
"Case
Number" so the user doesnt have to enter the case number for the
report.