• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

14. SQL Server > 14.7. Use Controls as Parameters for the Row Source of Combo a...

14.7. Use Controls as Parameters for the Row Source of Combo and List Boxes in an ADP

Problem

Cascading combo boxes—where the list in the second combo box changes based on the selection in the first—can provide an effective way to limit the number of records returned from SQL Server. You have a series of cascading combo boxes that are based on stored procedures that have parameters. The value that the user selects in the first combo box should determine the contents of the list in the second combo box. How do you pass the parameter values from one combo box to another?

Solution

You can easily use a stored procedure as the row source for a combo box in Access 2002 or later, as long as the stored procedure doesn’t have a parameter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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