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

Chapter 29. Programming Combo and List B... > Adding Code to Create the Query's SQ...

Adding Code to Create the Query's SQL Statement

Selections you make in the combo boxes return the values required for the WHERE clause criteria of the query that serves as the Row Source property of the lstOrders list box. Selecting an item in the combo list returns the value of the bound column to the combo box's Value property. The Row Source property value of the lstOrders list box created by the List Box Wizard is as follows:

SELECT [qryCombo1].[CompanyName],
      [qryCombo1].[OrderID], [qryCombo1].[ShippedDate]
   FROM [qryCombo1];


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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