access 2000 cascading combi

R

Robert Painter

Hi
Am building db and am new to it. Problem is cannot get combi boxes to work.
Have 4 tables:employees,workexperience, experiencecategory and
employeeexperience. have relationships many to many for employees -
workexperience thru employeeexperience and one to many experiencecategory to
workexperience.
Trying to use combi to insert workexperience(71 types in 5 categories) but
cannot seem to master it. Have been working on for week now but just getting
more and more confused.
Anyone help please

Robert
 
N

NetworkTrade

generally:

in the AfterUpdate of combo1 you need to have its value inserted into the
appropriate text field

then you need combo2 sourced on a query that has it's filtering parameter
based on combo1's value - and this combobox must be requeried in the combo1
AfterUpdate event also

and you repeat this idea with as many cascading as you need...
 
R

Robert Painter

Hi and thanks for quick response. Have just been trying again but with no
success. in the AfterUpdate of combo1 (experiencecategory) Where does the
result go. Not at all familiar with access so your answer means not a lot
really. Can find my way around properties box and code builder but do not
know how to program at all
 
Top