How to create SQL Statement from Combobox Selections
by admin on Tuesday, September 10th, 2013 | No Comments
This video will show you how to
use checkboxes to create a SQL statement
and formulate a recordsource for a form.
In the sample database, a certain product can
be combined with other products to create a package.
We want to select the products belonging to each
package.
In this video you will be shown how to
see the products for the selected basket
Concepts discussed:
combobox
subform
sql form recordsource
disconnected form
command button action
Option Compare Database '======================================================== 'DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 'ERIK LOEBL(713)409-7041 'EMAIL: erik@loeblcomservices.com 'WEB: http://loeblcomservices.com '======================================================== Private Sub btnSelectItems_Click() Dim strField As String Dim strSQL As String strField = Me.cboChoices strSQL = "SELECT product_name, " & strField & " FROM products WHERE " & strField & " = TRUE" Me.frmBasketItemsSub.Form.RecordSource = strSQL Me.frmBasketItemsSub.Form("txtProducts").ControlSource = strField Me.frmBasketItemsSub.Form("lblSelected").Caption = strField End Sub
Click here for more information on comboboxes and filter related posts.
Click here for the file:
How-to-create-SQL-Statement-from-Combobox-Selections.accdb