Combo box updating depending on previous selection - like car insurance web sites?

[Kernel Kev]

Hi, im doing a college assignment using Access and i seem to have hit a hard rock thats getting in my way. I will explain my task solution in hope you may be able to explain the best way to do this:

A motorcycle workshop uses a paper based system to store their job records, each new customer has a job card, and returning customers have new job cards.

Some bikes come back with the same problem, but the sloution may have been forgoten, so i want a system that records each bikes problems and has notes on how it was repaired, this way, when a bike comes in with a common problem, a search can be made for same bikes with the same problem to cut back on time finding the problem.

Anyways, i hope this is making sense, so to enter the problem, i want a combo box that has options like: Mechanical, Electronic, Bodywork, Service, MOT. then once a field is selected the combo box below changes it values so if Mechanical was selected the next box would be: Engine, brakes, steering... etc.

If it was MOT, then the second would be: oil, plugs, full service, etc.

So basically like what insurance websites have when the car model combo box changes depending on the manufacturer.

If someone could explain how this is done i would be extremely grateful and i appologise if this is a repeat question (i have searched but i dont honestly know what im searching for), because im a mod on a sony psp forum and know how many n00b questions come up.

But as i said, any help would be awesome.



Kev

[missinglinq]

Click here to learn more. The general concept is called Cascading Comboboxes.

Welcome to TheScripts!

Linq ;0)>

[Kernel Kev]

Dude, i cannot thank you enough, i thought i knew a fair amount about computers, i am a worthless nothing around you lol.

Cheers again.

*bookmarks page*

[Kernel Kev]

Umm, ok i have a problem now.

I have followed this tutorial as much as i could, but it dosent seem to be working.

Has anyone got a working version of this? If so could it be sent to me, or uploaded etc?

The first box is coming up with the company names i put in but the second is still showing all the employee names.

Thanks



Kev