New To Access and having trouble with synchronized fields

I hope someone can help me. I am pretty new to access and am building a form
that uses synchronized combo boxes. I am able to make it work using 2 boxes.
i.e., Customer Name and Ownership Codes. I’m having problems when I try to
set a similar scenario up for three or more choices. I want to set it up so I
get cascading information for categories, equipment, and levels. If the user
clicks on a category, i.e., Engines, then I want to see associated equipment
information populated in the second box. When the user chooses the equipment
type I want them to then be able to choose the levels based on the
engine/equip choice they made. I have 7 different categories and 50+ types of
equipment and levels. The equipment and levels contain different information
but all 3 things need to tie. I hope this is making sense. I am confusing
myself trying to get this to work and think I may be making it harder then it
has to be. Can someone help me?

Answered in Forms newsgroup!

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications





"AnnieV" u35047@uwe wrote in message news:73a7b890217ea@uwe...
I hope someone can help me. I am pretty new to access and am building a
form
that uses synchronized combo boxes. I am able to make it work using 2
boxes.
i.e., Customer Name and Ownership Codes. I'm having problems when I try to
set a similar scenario up for three or more choices. I want to set it up
so I
get cascading information for categories, equipment, and levels. If the
user
clicks on a category, i.e., Engines, then I want to see associated
equipment
information populated in the second box. When the user chooses the
equipment
type I want them to then be able to choose the levels based on the
engine/equip choice they made. I have 7 different categories and 50+ types
of
equipment and levels. The equipment and levels contain different
information
but all 3 things need to tie. I hope this is making sense. I am confusing
myself trying to get this to work and think I may be making it harder then
it
has to be. Can someone help me?