Cascading Combo Boxes

[Benny1973]

Hi

I have trawled this forum searching for help with cascading combo boxes, it was very helpful but alas I need that bit more.

I have 2 combo boxes and the result is displayed in a subform. The problem is that it will only display one selection made from the Combo boxes and I need multiple selections on display in the record.

It is a parts job worksheet in a garage where multiple work is required on a vehicle. It is based on Work Type and Work Codes which then bring up the detailed description.

The first Combo Box is Work Type and this allows you to select letters. The second Combo Box is Work Code and this allows you to select numbers.

I used the example I found on here but haven't changed the field names as I daren't alter the coding until I know it will display multiple selections in the subform of the record.

I attach the database to see of anyone can help me, ppllleeeaaassssee. I woul dbe most grateful if you could make the changes and zip it back up as I ain't no VB programmer.

 

[Benny1973]

Stuck

Uncle Gizmo

Many thanks for pointing me in the right direction, it is great that there is an example of exactly what I need. BUT I can't manipulate this, if you look at the design of the database the tables aren't there and like i said I can't do the programming bit. I don't have a clue where to start first

 

[Benny1973]

Uncle Gizmo

I'm not expecting somebody to do it for me I'm hoping to find a database with tables and forms there for me to work from. I have spent hours and hours on this and it's only one part of the database. As I said I'm not a programmer so need to actually see the workings of the database ie the tables and the forms. I have worked on the example you sent back to me but am getting rather confused

 

[Benny1973]

I'm not sure if this is going to give me exactly what I want. I will explain the whole database in more detail.
Vehicle Reg No X333 JJJ arrives at the workshop and is allocated job no 888. A paper form is completed by the workshop staff - this is the workshop job sheet where they manually tick what needs doing to the vehicle as follows

AIR 09 Overhaul air con. system
BRA 05 Replace comp.

Then this is input in to the database and an invoice is raised. This means that a record in the job sheet table relates to the job no which relates to the reg no and AIR can be slected from one list then 09 Overhaul air con. system be selected from the next list, this is to be displayed in a sub form, then BRA is selected from the list and 05 Replace comp is selected from the second list, this is then displayed in the sub form underneath AIR.

Then all this is the history of what happened to that particular vehicle. Every vehicle has it's own record and a full audit trail.

I spent hours last night looking through the Internet to see if cascading combo boxes give me the answer and I don't think they do. I'm not sure whether it should be a cascading list http://www.fontstuff.com/access/acctut10.htm

 

[Benny1973]

Hello there, I have spent a few days still searching for my amswer and found some help based upon searching the forum for cascading lists. There is a database there posted by Scouser called Car Sales Database. This is exactly what I need. So I have spent 2 days working on this and am nearly there. I have had to post a question to Scouser as his second combo box is based onn a query but hte query is empty and bringin up an error.

Not sure if you're interested in having a look, Debbie

 

[Benny1973]

Hi

Many thanks that's the cascading combo boxes complete and working great, I've spent mroe than a week on this problem day and night and even in my sleep!!

I may sleep well tonight now, many thanks
Debbie