I have a report which has a stored procedure as its record source. The stored proc requires 1 input parameter which I am prompted to enter when I do a print preview. My question is when I want to print the report from a form how do I pass the input parameter for the stored procedure before I am prompted to enter it so the prompt is not displayed to the user?
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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stored Procedure as Report record source 1
- Thread starter gostrom
- Start date
Hi!
Put a textbox on your form to allow the user to input the criteria. Then in the criteria line of your stored procedure use the following:
[Forms]![YourFormName]![YourTextBox]
This will automatically use the information from the text box on the form to open the report.
hth
Jeff Bridgham
Put a textbox on your form to allow the user to input the criteria. Then in the criteria line of your stored procedure use the following:
[Forms]![YourFormName]![YourTextBox]
This will automatically use the information from the text box on the form to open the report.
hth
Jeff Bridgham
-
1
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
