linking dropdown list options

[ahoodless]

hi i have a problem that I have tried desperately to tackle but cannot
seem to complete. basically i am trying to create a form with three
dropdown lists, the tricky part is i want the 3rd drop down box's
options to be dependant on the choice made in the 2nd dropdown...and
the 2nd dropdown's options to be dependant on the choice made in the
1st dropdown. For example:

1st dropdown

product 1
product 2
product 3

2nd dropdown (if product 1 is chosen)

version a
version b
version c

2nd dropdown (if product 2 is chosen)

version d
version e
version f

3rd dropdown (if version a is chosen)
part za
part zb
part zc

thanks in advance for anyone that knows how to pull this off!

[Douglas J. Steele]

See whether the example in http://www.mvps.org/access/forms/frm0028.htm at
"The Access Web" helps.

The idea is that in the AfterUpdate event of the first combobox, you need to
modify the RecordSource property of the second combobox so that it's looking
for whatever values are appropriate for the content of the first box.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"ahoodless" <da**********@hotmail.com> wrote in message
news:53**************************@posting.google.c om...

hi i have a problem that I have tried desperately to tackle but cannot
seem to complete. basically i am trying to create a form with three
dropdown lists, the tricky part is i want the 3rd drop down box's
options to be dependant on the choice made in the 2nd dropdown...and
the 2nd dropdown's options to be dependant on the choice made in the
1st dropdown. For example:

1st dropdown

product 1
product 2
product 3

2nd dropdown (if product 1 is chosen)

version a
version b
version c

2nd dropdown (if product 2 is chosen)

version d
version e
version f

3rd dropdown (if version a is chosen)
part za
part zb
part zc

thanks in advance for anyone that knows how to pull this off!

[Larry Linson]

You'll find an example that may be of assistance at
http://accdevel.tripod.com/dwnindx.htm -- "QueryByForm with Three Combo
Boxes". The key is using the AfterUpdate event to Requery the other Combo
boxes. That example is in Access 97 format, but AFAIK will convert without
problem to any later version of Access.

Larry Linson
Microsoft Access MVP
"ahoodless" <da**********@hotmail.com> wrote in message
news:53**************************@posting.google.c om...

hi i have a problem that I have tried desperately to tackle but cannot
seem to complete. basically i am trying to create a form with three
dropdown lists, the tricky part is i want the 3rd drop down box's
options to be dependant on the choice made in the 2nd dropdown...and
the 2nd dropdown's options to be dependant on the choice made in the
1st dropdown. For example:

1st dropdown

product 1
product 2
product 3

2nd dropdown (if product 1 is chosen)

version a
version b
version c

2nd dropdown (if product 2 is chosen)

version d
version e
version f

3rd dropdown (if version a is chosen)
part za
part zb
part zc

thanks in advance for anyone that knows how to pull this off!