Re: 2 Combo Boxes
From: Richard Connell (RichardConnell_at_discussions.microsoft.com)
Date: 11/23/04
- Next message: John Spencer (MVP): "Re: Working out costs per trainee"
- Previous message: Jamie Thomson: "Re: How to get data from Analysis Services cubes into Access"
- In reply to: Marshall Barton: "Re: 2 Combo Boxes"
- Next in thread: Richard Connell: "Re: 2 Combo Boxes"
- Reply: Richard Connell: "Re: 2 Combo Boxes"
- Reply: Marshall Barton: "Re: 2 Combo Boxes"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 15:07:03 -0800
I understand the logic but I cannot get to grips with the programming. Could
you send me the code using the following template so I can figure it out.
Combo box 1 allows the user to select 10 machines.machine1 -> machine 10.
Once the user has selected the machine in combo box 1 they will go to combox
box 2 which will now have a list of machine parts in the list. ie. If they
select machine1 in combo box 1 then combo box 2 will have the following
choices eg. machine1_part1 -> machine2_part2 -> machine3_partZ. If they have
selected machineX in the first combox box then the "code" will list all the
parts from machinex table.
All of the different machines are in one table on their own
All the parts of machine1 are in a different table on their own
All the parts of machineX are in a different table on their own.
I know this sounds dum but it would be very nice if you could send me an
example of the code
Thanks Marshall
"Marshall Barton" wrote:
> Richard Connell wrote:
>
> >Hi - I have 2 combo boxes at the start of a form. The first one allows the
> >user to selct one of 10 different machines on our factory. How I can set up
> >the second combo box such that it will display a different list for each
> >value that may be selected in the first combo box. The second combox box will
> >have a list of different parts of a machine and since each part is different
> >the values displayed in the second combo box must be updated when the first
> >combo box is selected and is it possible to prevent the user from accessing
> >the second box before they have selected a value from the first box. HELP.
>
>
> See http://www.mvps.org/access/forms/frm0028.htm
>
> --
> Marsh
> MVP [MS Access]
>
- Next message: John Spencer (MVP): "Re: Working out costs per trainee"
- Previous message: Jamie Thomson: "Re: How to get data from Analysis Services cubes into Access"
- In reply to: Marshall Barton: "Re: 2 Combo Boxes"
- Next in thread: Richard Connell: "Re: 2 Combo Boxes"
- Reply: Richard Connell: "Re: 2 Combo Boxes"
- Reply: Marshall Barton: "Re: 2 Combo Boxes"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
