I have a form which contains 2 subforms.
form SubNames has a list of people with different skills each person may have a number of skills.
this source is from a query and form is a continuous form
Form Jobs has a list of clients who want a skill(s) at a particular.
What I want is, if client clicks on field in form 'jobs' (say COSS field), then I want the SubNames form to refresh with names of people who have the COSS skill. If client clicks on another skill on form 'jobs' (say T/S field) then I want the SubNames form to refresh with names of people with the T/S skill.
I understand were the code need to go on the 'jobs' form, but what I can't work out is how to requery the form Subnames, but with a statement like, were COSS = true or were T/S = true depending on which one was selected in jobs form
Hope question makes sense.