Printing a report from a form

[bill1856]

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?

 

[flyover789]

in your query:

... WHERE [incident number] = Forms!yourForm!txt_Incident_Number

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.

http://www.mserrasystems.com

[blue]Database_Systems and _Applications shared across all Business_Areas[/blue]

 

[bill1856]

Perfect! Thank you very much.