O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with Input Parameters

Server filters are great if you need to filter the data from a table or view. However, they don’t work if your recordset is an in-line function or a stored procedure. Fortunately, in-line functions and stored procedures can use input parameters to control the data they return.

When you use a parameter query as the record source for a report, you can let Access prompt the user for the parameters when the user opens the report. However, reports in an Access project also have an input parameter that allows you to specify an alternative way to resolve parameters that are required in the in-line function or stored procedure that serves as the report’s record source.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required