By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,728 Members | 2,488 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,728 IT Pros & Developers. It's quick & easy.

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

P: 4
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
Nov 21 '07 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Click here to learn more. The general concept is called Cascading Comboboxes.

Welcome to TheScripts!

Linq ;0)>
Nov 21 '07 #2

P: 4
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*
Nov 21 '07 #3

P: 4
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
Nov 23 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.