Combo boxes

[daredevildan25]

I am trying to create a helpdesk dbase for my employer, and i have created my tables, and my form. I am trying to get my combo boxes to link together.

CATfldCode
INVfldItem
INVfldMake
INVfldModel

These are the four combo boxes that i am trying to link together.
They should work like this; when the CATfldCode has been selected, it will populate the INVfldItem dropdown with only items relating to the Code that was selected. The user can then choose an item from the list, and then when they have made their choice, the INVfldMake dropdown will populate with only the Make that relates to the item. Once again, the user has a choice between what make they want to choose. Once they have made their choice, the final dropdown INVfldModel will populate with All model numbers relating to the Make that was chosen in the previous dropdown. It sounds like a very difficult task for me to perform, and i don't have that much experience with access. If anyone has any ideas, please let me know.

P.S. I can also provide a sample of the database if it is needed.

ALSO, I HAVE NO CLUE HOW TO DO VBA CODING
I saw some of the other posts, but i don;t understand what they mean

Thanks again

 

[skwilliams]

Attached is a word document explaining cascading combo boxes.

HTH

 

[daredevildan25]

What you gave me was one combo box updating within itself. What i need is this.
When you choose a Category From the CATfldCode field, it will populate the INVfldItem field with only items relating to that particular category.

You can then choose a particular item from this field, and when you do, it will populate the INVfldMake drop down with only Makes that relate to the particular item that was chosen.

From there you can even go one further, and select a specific make from the dropdown, and when you do, it will populate the INVfldModel field with only models relating to taht particular make.

So, basically when the whole list has been filled out, you will have something like this.

CATfldCode = CO
INVfldItem = Computer
INVfldMake = Tandex
INVfldModel = XGY866


Sorry i wasn't explaining myself more clearly.

I also have no clue when it comes to VBA Programming.

 

[skwilliams]

This example is for cascading combo boxes.

So if "Smith" is selected from the lastname combo box. If you look at the firstname combo box you should just see the first names of all the people whose last name is "Smith" and no one else.

Is that what you're looking for or am I way off base.

 

[daredevildan25]

Yes That is what i want, but using your example with my info, when you choose a CATfldCode, it will show all the INVfldItems that relate to that CATfldCode yes. Now i have to go further with it. From the list of INVfldIttems, i am able to make a choice with one of the Items in the list. Once that item has been selected, it will show me all models that relate to that item in the INVfldMake field. From the INVfldMake field, i can choose a make, and when i do, the last field(INVfldModel) will be populated with all models relating to that make. Finally when all is done, I am able to narrow down a particular piece of equipment that is giving me the problem. All the four field will show the CATfldCode, INVfldItem, INVfldMake, and INVfldModel of a specific item.

 

[skwilliams]

This example is made to do what your talking about. If you would like to post this database, I'd be happy to look at it over the weekend.

 

[daredevildan25]

Here You Go, and thanks again. It is greatly appreciated

 

[skwilliams]

Did you forget to post the attachment. I don't see it.

 

[daredevildan25]

it is 807Kb, i can't attach it
Can i send it to your email address maybe