Re: New To Access and having trouble with synchronized fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

First of all you need the right tables:
TblCategory
CategoryID
Category

TblEquipment
EquipmentID
CategoryID
Equipment

TblLevel
LevelID
EquipmentID
Level

You need three queries for your combobox. For the first combobox, the query
is based on TblCategory. For the second combobox, the query is based on
TblEquipment. For the third combobox, the query is based on TblLevel. In the
second query, put the following expression in the criteria of CategoryID:
Forms!NameOfYourForm!NameOfFirstCombobox. In the third query, put the
following expression in the criteria of EquipmentID:
Forms!NameOfYourForm!NameOfSecondCombobox.

Put the following code in the Enter event of the First combobox:
Me!NameOfFirstCombobox.DropDown

Put the following code in the AfterUpdate event of the first combobox:
Me!NameOfSecondCombobox = Null
Me!NameOfSecondCombobox.Requery
Me!NameOfThirdCombobox = Null


Put the following code in the Enter event of the second combobox:
Me!NameOfSecondCombobox.DropDown

Put the following code in the AfterUpdate event of the second combobox:
Me!NameOfThirdCombobox = Null
Me!NameOfThirdCombobox.Requery

Put the following code in the Enter event of the third combobox:
Me!NameOfThirdCombobox.DropDown

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx



"AnnieV" <u35047@uwe> wrote in message news:73a7a5e1fd2da@xxxxxx
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?



.

Quantcast