I’m a new member here (just joined last night) & I’ve been struggling for days on in with how to create 2-separate cascading Combo Boxes in 1-Form. I come from another Access Forum site which I have receive tons of help (literature & links to videos) rDataPig, etc. egarding this topic, which I’ve watch countless times. I cannot comprehend the concept of creating cascading Combo Boxes in this one Form & I’m asking in anyone here might be willing to set up 2-cascading Combo Boxes for me if I send database?
The Database is a used car dealership which has 5-locations. On the Form, amounts the any fields, ‘Make,’ ‘Model,’ ‘Location,’ & ‘SalesRep,’are the focus fields. Here’s what I need:
1) 1.a) I need the ‘Make’ to be a Combo Box which only contains the “Makes” of the Vehicles (e.g. Ford). 2.a) With the ‘Model’ Combo Box I only want to see/choose from the “Models” that are fords (e.g. Mustang).
2) 2a)With the ‘Location’ Combo Box, I only want it to list the 5-different locations. 2b) in the ‘SalesRep’ combo Box (each dealership location has 5-different “SalesRep”). So, when I choose a particular ‘Location’ in my ‘SalesRep’ Combo Box I only want to see/choose those “SalesRep” from that “Location.”
I don’t want to come across too demanding, bold, or lazy. I’ve been at this for days & have tried everything & beyond, but it won’t fly. I’m just asking if someone might be willing to set up these 2-Combo Boxes & in doing so I think I’ll learn that way.
Only problem, I don't have enough post to provide the dbs or the link, damn!
The Database is a used car dealership which has 5-locations. On the Form, amounts the any fields, ‘Make,’ ‘Model,’ ‘Location,’ & ‘SalesRep,’are the focus fields. Here’s what I need:
1) 1.a) I need the ‘Make’ to be a Combo Box which only contains the “Makes” of the Vehicles (e.g. Ford). 2.a) With the ‘Model’ Combo Box I only want to see/choose from the “Models” that are fords (e.g. Mustang).
2) 2a)With the ‘Location’ Combo Box, I only want it to list the 5-different locations. 2b) in the ‘SalesRep’ combo Box (each dealership location has 5-different “SalesRep”). So, when I choose a particular ‘Location’ in my ‘SalesRep’ Combo Box I only want to see/choose those “SalesRep” from that “Location.”
I don’t want to come across too demanding, bold, or lazy. I’ve been at this for days & have tried everything & beyond, but it won’t fly. I’m just asking if someone might be willing to set up these 2-Combo Boxes & in doing so I think I’ll learn that way.
Only problem, I don't have enough post to provide the dbs or the link, damn!