I know how to print a report from a form but here's my question: My report runs on a query. The only criteria field prompts the used to enter an 'incident number'. Is there any way to automaticly pull the 'incident number' from the current open form to satisfy that criteria?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Printing a report from a form
- Thread starter bill1856
- Start date
flyover789
Programmer
in your query:
txt_Incident_Number is the name of the control, that holds the incident number to be pulled by the query.
HTH,
fly
[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]
Martin Serra Jr.
[blue]Database_Systems and _Applications shared across all Business_Areas[/blue]
Code:
... WHERE [incident number] = Forms!yourForm!txt_Incident_Numbertxt_Incident_Number is the name of the control, that holds the incident number to be pulled by the query.
HTH,
fly
[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]
Martin Serra Jr.
[blue]Database_Systems and _Applications shared across all Business_Areas[/blue]
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
