Synchronized combo boxes and multi select list boxes

[Robert C]

I have a combo box - cboSupplierName - which is synchronized to another combo box - cboProductCategory - on the same form - frmOrders. Thus suppliers only appear in the second combo box if they fall within the category selected in the first. This category is initially selected on a combo box on the main form which shows all the supplier’s details.

What I would like to do is employ a multi select list box on the main suppliers form, so that any given supplier can fall within any number of categories. Then when I select say the Fixings category from the cboProductCategory on the frmOrders, all the suppliers who have this category selected on the multi select list box will appear in the cboSupplierName on the frmOrders
Is this possible?

Any help offered would be greatly appreciated.

 

[namliam]

Yes doable....

You now have a 'simple' cascading combo thing going... In order for this to work you will have to build the SQL for the 2nd combobox from VBA. Hope this helps, if you need more help let me know....

Regards

 

[Robert C]

Thanks namliam

Yes, I'm afraid I do need help. My VBA knowledge is sketch at best, so any advice or more detailed help would be very greatly appreciated.

Thanks again for your reply

Cheers

Robert

 

[namliam]

Its hard to create an example, so out of the blue. Post a sample of what you have (zip it first!) and i/we will see what can be done....

The (my) general idea would be to use the on lost focus of the first combo box to trigger some VBA that would build your SQL for the second combo and requery....

Regards

 

[Robert C]

Hi namliam

It's hard to know what to send - the database is too big, even when zipped, to send in its entirety and its very hard to split it up into bits. If I get a chance maybe I'll make a small sample dbase showing what I'm after.

Thanks very much again


Robert

 

[namliam]

0) Create a copy of the DB

1) delete everything of the form but the list box and combo box...

2) delete all non essential tables

3) Detete all records from the tables you need for the boxes in 1)

4) create a little sample content for the tables in 3)

Regards

The Mailman

 

[Robert C]

Hi Mailman

Tried to delete as much as possible - still too big to send to the forum. Can I email it to you direct?

Rob

 

[namliam]

Try my hotmail...

 

[Robert C]

Hi Namliam

I sent a version to namliam@hotmail.com. Did it arrive??


Cheers


Rob

 

[namliam]

I am sure it did, but its not my hotmail... I thought one could find it in the profile but i just checked... You cant....

Try *Deleted email addres*, i will catch it tomorrow

Regards

The Mailman

 

[namliam]

The sample you send me doesnt work! You didnt send me a working DB....

Try again...

Regards