One field on form determines drop down list on other field

[tinynoo]

Can anyone tell me how to do the following:

I have a drop down list on a field on a form. Depending on what is selected on this list will determine the option on the next drop down field.

E.G

List 1
Dog
Cat
Fish

Following lists appear depending on which in List 1 is selected:

List 1a or List 1b or List 1c
Fido Molly Fred
Laddy Misty Wanda
Sam Tom Nemo

 

[ColinEssex]

Search for 'cascading ComboBoxes' - this occurs weekly

Col

 

[tinynoo]

Isn't there a way to do it without knowing visual basic?

 

[gemma-the-husky]

its not a lot of Vb, but it does need some, i think

 

[missinglinq]

Isn't there a way to do it without knowing visual basic?

In a word? No!

 

[tinynoo]

I have tried it but it comes back with errors like most things I do with Access! For example, I have created 5 search combo boxes with the wizard and only 3 work, but they were all created exactly the same way.

 

[Rabbie]

I have tried it but it comes back with errors like most things I do with Access! For example, I have created 5 search combo boxes with the wizard and only 3 work, but they were all created exactly the same way.

Acces has a fairly steep learning curve. if you can post acopy of your DB we may be able to find what the problem is.