Data from form to report

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

Guest

I have a form that when opened prompts me to enter specific points of what
data I want to see, such as a state code to see data from Indiania, etc.
(Simplified)

I have a report that uses the same query and when I am in the form and click
on the print report button I have to enter the state code again.

How do I make the report print the data displayed in the form without
haveing to enter the qualifying data points again?

Thanks,
Scott
 
TSL said:
I have a form that when opened prompts me to enter specific points of what
data I want to see, such as a state code to see data from Indiania, etc.
(Simplified)

I have a report that uses the same query and when I am in the form and click
on the print report button I have to enter the state code again.

How do I make the report print the data displayed in the form without
haveing to enter the qualifying data points again?
Click to expand...


Time to stop using those query parameter prompts.

Add a text box to your form's header section for users to
enter the state. Add a line of code to the text box's
AfterUpdate event procedure:
Me.Requery

Then change the query to use the text box for the state
field's criteria instead of a prompt string. The parameter
will look like:
Forms!yourform,thetextbox
 
Back
Top