• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Setting 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 form, you can let Access prompt the user for the parameters when the user opens the form. However, forms in an Access project also have an input parameter that allows you to specify an alternative way to resolve parameters that are required for the in-line function or stored procedure that serves as the form’s record source.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint