View Full Version : Form to Report Preview


kermit5
11-05-2001, 06:53 AM
Is there a way to set up a command button that will open a report based on a query using information from the current screen?

For example, if I have a form opened for a change request for a particular project and I would like to preview THIS CHANGE REQUEST report, it would take the project number and the change request number automatically from this record without additional user input and use those for the query parameters to pull the appropriate information for the report?

Pat Hartman
11-05-2001, 07:04 AM
Rather than using parameters in the report's query, use the filter option of the OpenReport Method. Look in help for syntax.