2 Data Bound List Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 list boxes bound to a database. The 1st list box displays services
ordered by the customer. I want the 2nd list box to display services not yet
ordered by the customer.

For example. My services are A, B, C, D and the customer has ordered A and B.

List box 1 should show A, B
List box 2 should show C,D

I have list box 1 working. Can someone give me some help as to how I need to
setup the query for list box 2? Thanks for your help.

Weste
 
The query below solved by problem.

SELECT Services.ServiceID, Services.ServiceName
FROM Services
LEFT JOIN (SELECT ServiceSales.SalesID, ServiceSales.ServiceID FROM
ServiceSales WHERE ServiceSales.SalesID = @Param1) AS B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieving Values from a Multi Select List Box 1
Excel Message box called if 1 of 3 options is entered. 4
Multi Select List Box in Access 0
Access MS access forms list box problems 1
Combo Box DropDown Style 1
Copying List box values/selection to a database of sorts 2
Confused about ComboBox and DataBinding 2
VBA- Excel Programming:- 0

Back
Top