Hi again all...I'm going to post another question even though I never got even one response on my previous one! #21591
I think perhaps that one was just too difficult to answer and this one I KNOW is possible and probably a breeze for some of you more experienced users. Both of these questions by the way are because I've been asked to create a database for work by which we can query employee skills and skill levels. It's got to be usable by non Access users so I'm doing it via a main control panel form. OK so...the database contains a number of tables which include Employees, Matrix, Skills and Skill Level Code. Some of these are just reference or lookup tables. I've created a form for which all the data needed resides in an underlying query called qryAll. It includes the EmpCode which is a primary key related to a specific employee. It also contains information such as skill, name, skill level, office location. I've created a form similar to the "Customers" form in the Northwind sample database where the user clicks on the record selector at the bottom and this brings up (in my case) a particular skill the employee possesses. All the data is from qryAll. The first subform shows the list of people that possess that skill. I would like to click on a specific person in that list and have the second subform show all the additional skills that person possesses (I don't mind if the originally selected skill is included). I've looked carefully at the Northwind example and got the first subform working fine. But I'm having a problem getting the second subform to pull up just the skills possessed by the selected person. Inotherwords, problems with linking subform 1 and subform2. Subform2 is pulling up all the skills listed in the underlying query. There also seems to be some problems with the coding I used as I am getting a message "Microsoft Access cannot find the field "SkillsSubform" referred to in your expression. I find this confusing because SkillsSubform is a form not a field and I used the same coding as the Northwind database just changing the name of the subform to match my situation. Any ideas what I might be missing? Thanks in advance. BJ
