Refine a Stored Query for a ListBox based on a selection in a Combo Box

[LenseOnLife]

Hi,

Just joined and also a fairly new geriatric programmer to the land of MS ACCESS VBA :(

I have a table called 'transactions' and a query called qryTransactions. This query selects all records based on whether or not a flag called 'Sold' is set to 'No'. Working fine.

I have a list box (Multi Columns) which has a RowSource set to qryTransactions.

So far so good, when form loads, I get all 'Not Sold' records in the List Box.

There is a ComboBox fed from a table of customers - basically the CustomerName. When I select a name, I want to limit the qryTransactions just to the customer name selected from the combo box.

QUESTION: Is there a simple way to make use of a clause like 'WHERE Customer_Name = cboBox.value' so that the RowSource of the ListBox reflects this WHERE clause.

P.S. seen loads of complex VBA contortions around this issue, but for this geriatric, surely there must be a simple solution :(

Thanks for having a read - any pointers appreciated

Oliver

[LenseOnLife]

OK, I've sorted it out

Dim strSql As String
strSQL = "Select SalesOrderId, TransactionDate, .... 
FROM tblSalesOrders 
WHERE  Customer_Name = '" & lstCustomers & "'"
lstTransactions.RowSource = strSQL
lstTransactions.Requery

And that's it :)

Oliver