Updating Table using cascading lists on Form

[Tom K]

Hope someone can assist me. I have little experience with VBA so I'm trying to use the brute force method to create a form that will update technical training course data. There are over 200+ technical training skill blocks that are broken down into Category>Subject>Skill Block. I set up a few queries to filter lists for each of those headers that allows me to cascade the selection. I can't figure out how to use the selected skill block and find that record in a table to update. (Everything I've tried causes me to add a new record in the table.) I attached a stripped down version of the file for someone to look at, if needed. Thanks in advance!

[ranman256]

The tEmployees need a subtable to track the courses they've taken....
tEmpTraining table
EmpID, ClassID, TrainDate


To add training, a form would have listboxs,
select tSkillBlockData.Cata
then Subject,
then Dbl-click SkillCode to run append query to add to tEmpTraining .

[Tom K]

I have the employee side done but stripped it from what I posted. What I'm trying to do now is allow specific course data to get changed as needed. Skill block estimated training times are hypothetical at this point but as "actual" times come in, we will update as needed. Since there are so many skill blocks, it's too cumbersome to do a single comb list on SkillCode, hence the cascade approach. (There are less employees, so I used the single comb box you mention on those forms.)

[Tom K]

Anyone else have any ideas?

[ssanfu]

I looked at your dB - you stripped out a little too much....

If I understood the question, you wanted to update the "EstDuration" field (among others). I modified the form "UpdatePlantSkillsData" - you had the "Category>Subject>Skill Block" controls bound, which meant the data changed when you selected something new.

In one form, the "Data Entry" property was set to True, which is why a new record was being entered.
There are other problems (IMHO) that need to be looked at/fixed.

I added a new button (yellow) on the main switchboard.


Maybe you could upload a complete copy of the dB - change any sensitive data (change names to Mickey Mouse, Fred Flintstone, etc), do a compact and repair, then compress (zip).