Query for a combo box

[daredevildan25]

I have Made a query called qryCategoryCode Within it i have four fields

CATfldCode
INVfldItem
INVfldMake
INVfldModel

What i would like to do is arrange it so that when i choose a specific category code, it will only show me the specific item that relates to that code. From the list that shows up in INVfldItem, i can choose a specific item related to that code, and when i do so, the INVfldMake field will populate with items that relate only to the different makes for the specific item. From the list of makes, i would like to be able to choose a specific make, and when i do the INVfldModel field will populate with only models that relate to that specific Make.

this query will be linked to four combo boxes, How Can i do this.
I don't understand alot about SQL, or VBA. I have looked at some of the cascading combo boxes within the forms section, to try and solve my problem, but i don't understand anything with the coding.

please help me

Thanks
I can let someone look at the dbase if needed

 

[jdjewell]

Here ya go...

http://users.impulse.net.au/predator/Downloads/ComboSamples.zip

The site that is from is:

http://users.impulse.net.au/predator/accessdownloads.htm

 

[jdjewell]

In the future

Try doing some searches on the forum with different combinations of keywords that uniquely describe your problem. If you don't get any results, then use more general descriptions. If you think you have too many results, try to be more specific.

Inevitably, it seems we always end up with 5,000 posts on the same topic, when we need a community of users who do a more efficient research job before submitting their questions.

Don't worry though, you are most certainly not alone.

 

[daredevildan25]

If i send you the dbase i am working on, do you think you would be able to tell me what i am doing wrong?

 

[daredevildan25]

If i send you the dbase i am working on, do you think you would be able to tell me what i am doing wrong?