Multiple categories - combos/list boxes

[BlahBlahBlah]

I would be very grateful to anyone who can help me on this as I have been trying for a long time to solve it. I have searched the forum and waded through loads of posts but never really found what I am looking for. It must be a common enough scenario but I have been unable to track down the answer.

I have a form - frmSuppliers - on this form I want the user to be able to select one or more product categories into which each supplier falls - possibly via a multi select list box???

Then on a form - frmOrders - I want the user to select a single category via a combo box, and all the suppliers who fall into this category to appear in another filtered combo box.

I understand the principle of cascading combo boxes, it is just the multi category bit I am stuck on.

To compound the problem I have another form - frmProducts - on which I want the user to be able to select one or more product categories into which any particular product falls.

This, in turn, will define which products appear on a subform of the frmOrders - sbfOrderDetails - after a particular product category and supplier has been selected.

Any answers will be very gratefully received.

 

[WayneRyan]

Blah,

If you use a multi-select list box to assign categories
to suppliers, then this implies that there is a table
that contains many rows of categories per supplier.

Your multi-select listbox will have code to keep the
entries in the categories current.

On your form, the rowsource for the combo box will
be:

Select Distinct(SupplierID)
From   tblSupplierCategories
Where  Category = '" & Me.FirstCombo & "'"

Wayne

 

[Estuardo]

To BlahBlahBlah

You're a lucky person, you may thank that i'm not Wayne, because if i would be, i would never help any one to show that infinite lack of respect for others, filling in the subscription Form with that kind of desconsiderative "id". It is obvious that you just came here for help, a not with the intention to help others or to learn from others.

I think we feel respected if you have descence to change that for a repectfull Identificator.

You see the Commintment, that Wayne has, respecting the way you want be called. Even when is and absurd wanted to be called that way.

With respect

Estuardo

 

[WayneRyan]

Estuardo,

No offense intended. Anyone is free to choose their own names
here and I see no harm in BlahBlahBlah,s although I really
didn't want to type the whole thing. OK, if I have to type it
all again I will be a little upset.

We are all friends here, no harm intended.

Wayne

 

[Estuardo]

Wayne:

My apologizes, if i was rude, and i'm glad you did not get offended. i trully try to respect every ones, choices, but freedom is one thing anarchy, is very different. I guess i exceed the limit too.

I'll try to not happen again.

Best regards

Estuardo

 

[BlahBlahBlah]

Estuardo:

I am very sorry for causing offence by my choice of name. It was really not my intention. All I want is to try and get some help in solving the problem I have with my database and in doing so hopefully help others who may have a similar problem. That's the thinking behind forums like this isn't it? When my knowledge of Access is as great as Wayne's or yours then I will certainly try to post replies to problems to which I know the solutions.

Wayne:

Thanks for the reply. I realise now that for both suppliers and products I need several fields to contain the various categories into which they fall. Do I need a hidden text box on both the suppliers and the products forms to receive the multiple selections in the form of a string or should I have a separate text box for each of the categories selected?

Sorry if my questions sound very basic – it is a long time since I wrote this database and I have gone very rusty.

Thanks again


BBB

 

[Rich]

Why would anyone find your username offensive

 

[BlahBlahBlah]

Rich:

No idea!!! Perhaps it means something rude in Portugese!


BBB

 

[WayneRyan]

BBB,

Hey, that's much easier to type. After I wake up, I'll reread this
and post something.

Wayne