combo box bound control to listbox

[Beng]

Hi there!

It could be a simple bound control example, but I am getting no where after attempting for several hours. Hope to get help in this forum.

I have a list box that displays output content from a query named QryCustomerSales. (contents are CustomerID, CustomerName, PO, POItem, ParNumber, etc). List box control name is lstCustomerSales. I want to have a combo box control that would bound to the list box's content. My combo box list control name is cboSelectCustomerID.

The list box content has a column "CustomerID" that displays duplicate data because of nature of the sales records - same customer can have different purchases. That is ok, but my problem is I can't get the combo box's control to display only single column CustomerID, with no repeating customer ID, and it must bound to the list box control. I'm using Acc2003. I attach my file. Thanks.

 

[jsv2002]

EDIT: Sorry missed the list box bit... thought it was a subform you need to use a statement in the criteria of your subform to filter the information in the listbox.

Perhaps something like this pick sales from the drop down has "fake data" in it, something I did for someone with a similar problem.

Good luck John

 

[Beng]

Thanks John. However, I am still looking for the solution on combo box control to bind to the listbox list. Reason being I want to build further code base on users can do a multiselection of items in the list box. Hope to get further tips on this. Thanks again.